how to get latest data with count and groupby code example

Example: sql groub by count

SELECT COUNT(Id), Country 
  FROM Customer
 GROUP BY Country