Sql groub by count

This article is tagged with: Sql groub by count and mysql

sql groub by count

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

sql count distinct group by

SELECT COUNT(DISTINCT program_name) AS Count,
program_type AS [Type]
FROM cm_production
WHERE [email protected]_number
GROUP BY program_type

This article is tagged with: Sql groub by count and mysql