SELECT
       CODE
	,  NAME
    , Round(cast(MAI as REAL)/cast(SOSU as REAL)*100,1)  as PERCENTAGE
FROM
   (
    select
         DRINK_HABITS.PF_CODE AS CODE
        ,PREFECTURE.PF_NAME AS NAME
        ,DRINK_HABITS.GENDER_CODE AS sei
        ,SUM(CASE WHEN CATEGORY_CODE = '110' THEN AMT ELSE 0 END) AS SOSU
        ,SUM(CASE WHEN CATEGORY_CODE = '120' THEN AMT ELSE 0 END) AS MAI
    from
        DRINK_HABITS 
    INNER JOIN PREFECTURE
        ON DRINK_HABITS.PF_CODE = PREFECTURE.PF_CODE
    WHERE
        DRINK_HABITS.GENDER_CODE <> '1'
    group by
        DRINK_HABITS.PF_CODE
    )
ORDER BY
      PERCENTAGE desc
    , CODE desc
;