create view production.aggregated_accounting_country_view as
SELECT countryid, 
         countryname AS country_name, 
         country_code, 
         continent,
         CASE continent
            WHEN 'North America' THEN 'N.America'
            WHEN 'Europe' THEN 'Europe'
            ELSE 'ROW'
          END AS continent_group,
          CASE continent
            WHEN 'North America' THEN '1 North America'
            WHEN        'Europe' THEN '2 Europe'
            WHEN 'South America' THEN '3 South America'
            WHEN          'Asia' THEN '4 Asia'
            WHEN        'Africa' THEN '5 Africa'
            WHEN       'Oceania' THEN '6 Oceania'
            WHEN    'Antarctica' THEN '7 Antarctica'
            ELSE '99 MARS_!!'
          END AS continent_ordered
  FROM production.dim_country;