Запрос на выборку по возрастным группам, как?

TRANSFORM COUNT(*)
SELECT table2.Disease, COUNT(*) AS Количество
FROM (table1 INNER JOIN table2 ON table1.idDisease = table2.idDisease) 
             INNER JOIN [INTERVAL] ON (table1.agePatient BETWEEN INTERVAL.Start AND INTERVAL.Finis)
GROUP BY table2.Disease, INTERVAL.NameInt
PIVOT INTERVAL.NameInt

SELECT idDisease, 
       -SUM(agePatient<10) AS A1, -SUM(agePatient BETWEEN 10 AND 19) AS A2, ......
FROM table1
GROUP BY idDisease

SELECT table1.idDisease, table2.Disease, 
-SUM(table1.agePatient>=0 AND table1.agePatient<10) AS до_10, 
-SUM(table1.agePatient>=10 AND table1.agePatient<20) AS с10_20, 
-SUM(table1.agePatient>=20 AND table1.agePatient<40) AS с20_40, 
-SUM(table1.agePatient>=40 AND table1.agePatient<60) AS с40_60, 
-SUM(table1.agePatient>=60 AND table1.agePatient<90) AS с60_90, 
-SUM(table1.agePatient>=90) AS СВ_90
FROM table1 INNER JOIN table2 ON table1.idDisease = table2.idDisease
GROUP BY table1.idDisease, table2.Disease;

TRANSFORM COUNT(*)
SELECT table2.Disease, COUNT(*) AS Количество
FROM (table1 INNER JOIN table2 ON table1.idDisease = table2.idDisease) 
             INNER JOIN INTERVAL ON (table1.agePatient BETWEEN INTERVAL.Start AND INTERVAL.Finis)
GROUP BY table2.Disease
PIVOT INTERVAL.NameInt;