select
   c.Code as Code, c.Name as Name, c.Continent as Continent, c.Region as Region, cls_o.languages as official_languages, c.SurfaceArea as surface_area, c.IndepYear as independence, c.Population as Population, c.LifeExpectancy as life_expectancy, c.GNP as GNP, c.GovernmentForm as form_of_government, c.HeadOfState as head_of_state
from
   Country c
   join (
      select
         cl.CountryCode, group_concat(cl.Language separator ', ') as languages
      from
         CountryLanguage cl
      where
         cl.IsOfficial = 'T'
      group by
         cl.CountryCode ) cls_o on c.Code = cls_o.CountryCode
      order by
         Name asc
      limit
         100 offset 0
;

select
   count(*) as count
from
   Country c
;