SELECT
  -- The continent from which events were reported, based on IP address
  geo.continent,
  -- The subcontinent from which events were reported, based on IP address
  geo.sub_continent,
  -- The country from which events were reported, based on IP address
  geo.country,
  -- The region from which events were reported, based on IP address
  geo.region,
  -- The city from which events were reported, based on IP address
  geo.city,
  -- The metro from which events were reported, based on IP address
  geo.metro
FROM
  `firebase-orangevalley-web-app.analytics_206829311.events_*`
WHERE
  _table_suffix BETWEEN '20190806'
  AND FORMAT_DATE('%Y%m%d',DATE_SUB(CURRENT_DATE(), INTERVAL 1 DAY))
GROUP BY
  1,
  2,
  3,
  4,
  5,
  6
LIMIT
  10