ソースコード
(SELECT (SELECT PF_NAME FROM PREFECTURE B WHERE A.PF_CODE = B.PF_CODE),ELEMENTARY,1 AS KIND FROM ENROLLMENT_STATUS A WHERE SURVEY_YEAR = 2020 GROUP BY PF_CODE)
union
(SELECT (SELECT PF_NAME FROM PREFECTURE B WHERE A.PF_CODE = B.PF_CODE),MIDDLE,1 AS KIND FROM ENROLLMENT_STATUS A WHERE SURVEY_YEAR = 2020 GROUP BY PF_CODE)
union
(SELECT (SELECT PF_NAME FROM PREFECTURE B WHERE A.PF_CODE = B.PF_CODE),HIGH,1 AS KIND FROM ENROLLMENT_STATUS A WHERE SURVEY_YEAR = 2020 GROUP BY PF_CODE)
union
(SELECT (SELECT PF_NAME FROM PREFECTURE B WHERE A.PF_CODE = B.PF_CODE),JUNIOR_CLG,1 AS KIND FROM ENROLLMENT_STATUS A WHERE SURVEY_YEAR = 2020 GROUP BY PF_CODE)
union
(SELECT (SELECT PF_NAME FROM PREFECTURE B WHERE A.PF_CODE = B.PF_CODE),COLLEGE,1 AS KIND FROM ENROLLMENT_STATUS A WHERE SURVEY_YEAR = 2020 GROUP BY PF_CODE)
union
(SELECT (SELECT PF_NAME FROM PREFECTURE B WHERE A.PF_CODE = B.PF_CODE),GRADUATE,1 AS KIND FROM ENROLLMENT_STATUS A WHERE SURVEY_YEAR = 2020 GROUP BY PF_CODE)
提出情報
提出日時2022/09/22 10:53:44
コンテスト第2回 SQLコンテスト
問題就学状況の表示変換
受験者Clover
状態 (詳細)RE
(Runtime Error: 実行時エラー)
メモリ使用量103 MB
メッセージ
SQLITE_ERROR: near "(": syntax error
テストケース(通過数／総数)
0/2
状態
メモリ使用量
データパターン1
RE
103 MB
データパターン2
RE
91 MB