how to count status in sql query by group by code example Example: sql groub by count SELECT COUNT(Id), Country FROM Customer GROUP BY Country