SELECT
  cc.m49,
  cc.country_name_en as country_name,
  gm.date,
  ROUND(AVG(gm.parks_percent_change_from_baseline),2) AS average_percentage_mobility_park,
  ROUND(AVG(gm.grocery_and_pharmacy_percent_change_from_baseline),2) as average_percentage_mobility_grocery_and_pharmacy,
  ROUND(AVG(gm.residential_percent_change_from_baseline ),2) as average_percentage_mobility_residential,
  ROUND(AVG(gm.retail_and_recreation_percent_change_from_baseline ),2) as average_percentage_mobility_retail_and_recreation,
  ROUND(AVG(gm.transit_stations_percent_change_from_baseline ),2) as average_percentage_mobility_transit_stations,
  ROUND(AVG(gm.workplaces_percent_change_from_baseline ),2) as average_percentage_mobility_workplaces
FROM
  `bigquery-public-data.covid19_google_mobility_eu.mobility_report` gm,
  `fao-maps.fao_common_dimensions.dim_country`  cc
WHERE
  gm.country_region_code = cc.iso2
GROUP BY
  cc.m49,
  cc.country_name_en,
  gm.date
ORDER BY
  cc.country_name_en 