select count group by code example
Example 1: sql count group by
SELECT gender, COUNT(*) FROM people GROUP BY gender;
Example 2: sql count distinct group by
SELECT COUNT(DISTINCT program_name) AS Count,
program_type AS [Type]
FROM cm_production
WHERE push_number=@push_number
GROUP BY program_type
Example 3: sql groub by count
SELECT COUNT(Id), Country
FROM Customer
GROUP BY Country