/*select country.Name, country.Capital, c.Population from country inner join city c on Capital = c.ID order by c.Population DESC LIMIT 5;
select sum(country.Population*c.Percentage/100) from country inner join countrylanguage c on country.Code = c.CountryCode where country.Continent="Europe" and c.Language="English";
*/

/*select CountryCode, count(*) from countrylanguage group by CountryCode;
*/

select CountryCode, count(IsOfficial) as T from countrylanguage where IsOfficial="T" group by CountryCode;
select CountryCode, count(IsOfficial) as F from countrylanguage where IsOfficial="F" group by CountryCode;/* on CountryCode = CountryCode;

/*
select * from countrylanguage;*/