--SDGSテーブル(SDGS)
--調査年(SURVEY_YEAR)が2022年
--推進自治体数の割合が高い順に都道府県を表示
--割合は各都道府県の「推進自治体数(PROMOTE_MUNICIPALITY) ÷ 全自治体数(MUNICIPALITY_TTL) × 100」で算出し、小数点第3位を四捨五入
--割合の降順
--PF_CODEの昇順

SELECT S.PF_CODE AS CODE,PF_NAME AS NAME,
ROUND(PROMOTE_MUNICIPALITY*1.00 / MUNICIPALITY_TTL*1.00*100,2 )AS RATIO
FROM SDGS AS S
JOIN PREFECTURE AS P
ON S.PF_CODE = P.PF_CODE
WHERE SURVEY_YEAR = 2022
ORDER BY RATIO DESC,CODE ASC;