usaspending_api/awards/management/commands/load_subawards_sql/110_enhance_with_pop_country.sql
-- Update place of performance country name.
update
temp_load_subawards_subaward
set
pop_country_name = cc.country_name
from
ref_country_code cc
where
cc.country_code = temp_load_subawards_subaward.pop_country_code and
temp_load_subawards_subaward.pop_country_code is not null;