with ohsome_snapshot_stats as (
select
  ne_id
  ,month
  ,-2 as userid
  ,0 as building_change
  ,0 as highways_change
  ,0 as landuse_change
  ,0 as remainder_change
  ,0 as healthcare_change
  ,0 as places_change
  ,0 as amenities_change
  ,buildings as building_creation
  ,roads_major as highway_creation
  ,0 as landuse_creation
  ,0 as remainder_creation
  ,healthcare as healthcare_creation
  ,places as places_creation
  ,amenities as amenities_creation
  ,0 as building_deletion
  ,0 as highways_deletion
  ,0 as landuse_deletion
  ,0 as remainder_deletion
  ,0 as healthcare_deletion
  ,0 as places_deletion
  ,0 as amenities_deletion
  ,0 as total_count
from data_preparation.osm_stats_per_country_per_month_ohsome
where month = '2010-01-01'
order by ne_id
)
insert into data_preparation.osm_user_contributions_per_country_per_month as per
select * from ohsome_snapshot_stats


