36岁以下的人
select * from tableWHERE EXTRACT(YEAR FROM age(CURRENT_DATE, table.birthday)) <= 36
3个月内年满60岁的人
select * from table WHERE CURRENT_DATE <= (table .birthday+ INTERVAL '60 years') and (table .birthday+ INTERVAL '60 years') <= CURRENT_DATE + INTERVAL '3 months'
平均年龄
SELECT FLOOR( AVG ( NULLIF ( birthday, NULL ) ) ) AS average_value FROM TABLE