SELECT
  cm.iso3 AS ISO3,
  cm.country_name_en AS Country,
  IMPORT_PORT AS Port,
  IMPORT_LAT AS Lat,
  IMPORT_LON AS Lon,
  IMPORT_DATE Date,
  CARGO AS Cargo,
  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,
  IMPORT_PORT,
  IMPORT_LAT,
  IMPORT_LON,
  IMPORT_DATE,
  CARGO
ORDER BY
  ISO3,
  Country,
  IMPORT_PORT,
  IMPORT_LAT,
  IMPORT_LON,
  IMPORT_DATE,
  CARGO