説明はありません
列はありません
SELECT prefcode AS prefecture_code, prefname AS prefecture, citycode AS city_code, CASE WHEN (regexp_full_match(citycode, '[0-9]{5}')) THEN ((citycode || CAST(((11 - ((((((6 * CAST(substr(citycode, 1, 1) AS INTEGER)) + (5 * CAST(substr(citycode, 2, 1) AS INTEGER))) + (4 * CAST(substr(citycode, 3, 1) AS INTEGER))) + (3 * CAST(substr(citycode, 4, 1) AS INTEGER))) + (2 * CAST(substr(citycode, 5, 1) AS INTEGER))) % 11)) % 10) AS VARCHAR))) ELSE NULL END AS lg_code, cityname AS city_name, address FROM people_flow.raw_city_master_2020