ソースコード
select sum(ELEMENTARY) from ENROLLMENT_STATUS where SURVEY_YEAR = 2020 group by PF_CODE
union all 
select sum(MIDDLE) from ENROLLMENT_STATUS where SURVEY_YEAR = 2020 group by PF_CODE
union all 
se   sum(HIGH)
from ENROLLMENT_STATUS
where SURVEY_YEAR = 2020
group by PF_CODE
union all 
select
    sum(ELEMENTARY), 
    sum(MIDDLE), 
    sum(HIGH), 
    sum(JUNIOR_CLG), 
    sum(COLLEGE), 
    sum(GRADUATE)
from ENROLLMENT_STATUS
where SURVEY_YEAR = 2020
group by PF_CODE
union all 
select 
    sum(ELEMENTARY), 
    sum(MIDDLE), 
    sum(HIGH), 
    sum(JUNIOR_CLG), 
    sum(COLLEGE), 
    sum(GRADUATE)
from ENROLLMENT_STATUS
where SURVEY_YEAR = 2020
group by PF_CODE
union all 
;
提出情報
提出日時2023/10/31 14:17:03
コンテスト第2回 SQLコンテスト
問題就学状況の表示変換
受験者fgdthfjgh
状態 (詳細)RE
(Runtime Error: 実行時エラー)
メモリ使用量79 MB
メッセージ
SQLITE_ERROR: near "se": syntax error
テストケース(通過数/総数)
0/2
状態
メモリ使用量
データパターン1
RE
79 MB
データパターン2
RE
76 MB