text: SELECT 
      t1.ContactName AS 'Nome',
      t1.Country AS 'País',
      COUNT(*) AS 'Número de compatriotas'
  FROM
      w3schools.customers AS t1,
      w3schools.customers AS t2
  WHERE
      t1.Country = t2.Country
          AND t1.CustomerId <> t2.CustomerId
  GROUP BY t1.ContactName, t1.Country
  ORDER BY Nome;
  