select TYPE,
       case when  Age < 10 then age end as ' Age<10',
       case when  Age between 10 and 20  then age end as ' Age 10-20',
       case when  Age > 20 then age end as ' Age>20'
from
your_table

SELECT type,
  age < 10               AS "Age < 10",
  age >= 10 AND age < 20 AS "10 <= Age < 20",
  age > 20               AS "Age > 20"
FROM table_name;

SELECT type,
  (SELECT COUNT(*) FROM table_name AS t2 WHERE age < 10 AND t2.type = type) AS "Age < 10",
  (SELECT COUNT(*) FROM table_name AS t2 WHERE age >= 10 AND age < 20 AND t2.type = type) AS "10 <= Age < 20)"
  ...and so on...
FROM table_name