create view production.aggregated_accounting_artist_view as 
SELECT artistid, 
               artistname AS artist_name,
               c_a.country_name AS artist_country
               -- labelid as artist_labelid
               --  TODO:  Include artist label information, joining on label.  But not needed now. 
        FROM production.dim_artist a
        LEFT JOIN production.aggregated_accounting_country_view c_a
        ON a.countryid = c_a.countryid;