SELECT
  cm.iso3 AS ISO3,
  cm.country_name_en AS Country,
  EXTRACT(YEAR FROM IMPORT_DATE) AS Year,
  SUM(QUANTITY) AS Quantity
FROM
  `fao-maps.fao_marcura.shipments_joined` sh,
     `fao-maps.fao_common_dimensions.dim_country` cm
WHERE
  sh.IMPORT_ISO3CODE = cm.iso3
GROUP BY
  ISO3,
  Country,
  Year
ORDER BY
  ISO3,
  Country,
  Year