TOPSIC SQL CONTEST

ソースコード

SELECT DISTINCT
    a.PF_CODE AS 都道府県コード,
    PF_NAME AS 都道府県名,
    (SELECT TOTAL_AMT FROM POPU_TRANSITION AS b WHERE SURVEY_YEAR = 2015 AND b.PF_CODE = a.PF_CODE) AS 総人口2015年,
    (SELECT TOTAL_AMT FROM POPU_TRANSITION AS c WHERE SURVEY_YEAR = 2020 AND c.PF_CODE = a.PF_CODE) AS 総人口2020年,
    ROUND(100*CAST((SELECT TOTAL_AMT FROM POPU_TRANSITION AS c WHERE SURVEY_YEAR = 2020 AND c.PF_CODE = a.PF_CODE) AS REAL)/CAST((SELECT TOTAL_AMT FROM POPU_TRANSITION AS b WHERE SURVEY_YEAR = 2015 AND b.PF_CODE = a.PF_CODE) AS REAL), 0) AS 人口増加率
FROM 
    POPU_TRANSITION AS a INNER JOIN PREFECTURE AS b ON (a.PF_CODE = b.PF_CODE)
ORDER BY
    100*CAST((SELECT TOTAL_AMT FROM POPU_TRANSITION AS c WHERE SURVEY_YEAR = 2020 AND c.PF_CODE = a.PF_CODE) AS REAL)/CAST((SELECT TOTAL_AMT FROM POPU_TRANSITION AS b WHERE SURVEY_YEAR = 2015 AND b.PF_CODE = a.PF_CODE) AS REAL) DESC,
    都道府県コード

提出情報

提出日時	2022/07/01 16:15:18
コンテスト	練習用コンテスト
問題	人口増加率分析
受験者	seiya3407
状態 (詳細)	WA (Wrong Answer: 誤答)
メモリ使用量	79 MB

メッセージ

テストケース(通過数／総数)

0/2

状態

メモリ使用量

データパターン1

78 MB

データパターン2

79 MB