count in sql using group by but output will be all 2 code example Example: sql groub by count SELECT COUNT(Id), Country FROM Customer GROUP BY Country