How to count total number of patients in a certain age group

Hello I would like to ask how can I have the total number of patients in certain distinct age groups using queries?

Answer

In MySQL. In other DBMS similarly, but you must precise what you use.

SELECT AgeGroup, COUNT(*) FROM Table GROUP BY AgeGroup ORDER BY AgeGroup.