Hi, thanks. The code worked, but here is the correct code.

=connect@l(“MySQL”)
=A1.query(“select * from countrylanguage”)
=A2.groups(countrycode;top(-3;percentage):top3).conj(top3)
=A1.query(“select code,name from country”)
=A3.switch(countrycode,A4:code).new(countrycode.name,language,percentage)

I changed the ‘code’ name to countrycode

Hi, good day! I have another issue!

How can I aggregate this data to get the average life expectancy grouped by continents and filtered by population > 10000000?

This should be my result set.