SELECT PF_CODE, AGE_CODE as '年齢コード', (CASE AGE_CODE WHEN 200 THEN '20～24歳' WHEN 210 THEN '25～29歳' WHEN 240 THEN '30～34歳' WHEN 250 THEN '35～39歳' ELSE '40～44歳' END) as '年齢階層名', SP_TIME_5 as'5時間未満',SP_TIME_6 as'5時間以上6時間未満',SP_TIME_7 as'6時間以上7時間未満',SP_TIME_8 as'7時間以上8時間未満',SP_TIME_9 as'8時間以上9時間未満',SP_TIME_9OVER as'9時間以上' FROM SLEEP_TIME_DTL WHERE PF_CODE='01000' OR PF_CODE='02000' OR PF_CODE='03000' OR PF_CODE='04000' OR PF_CODE='07000' GROUP BY AGE_CODE HAVING AGE_CODE='200' OR AGE_CODE='210' OR AGE_CODE='240' OR AGE_CODE='250' OR AGE_CODE='280' ORDER BY AGE_CODE