SELECT
  -- The device category (mobile, tablet, desktop)
  device.category,
  -- The device brand name
  device.mobile_brand_name,
  -- The device model name
  device.mobile_model_name,
  -- The device marketing name
  device.mobile_marketing_name,
  -- The device model information retrieved directly from the operating system
  device.mobile_os_hardware_model,
  -- The operating system of the device
  device.operating_system,
  -- The OS version
  device.operating_system_version,
  -- IDFV (present only if IDFA is not collected)
  device.vendor_id,
  -- Advertising ID/IDFA
  device.advertising_id,
  -- The OS language
  device.language,
  -- The device's Limit Ad Tracking setting
  device.is_limited_ad_tracking,
  -- The offset from GMT in seconds
  device.time_zone_offset_seconds,
  -- The browser in which the user viewed content
  device.browser,
  -- The version of the browser in which the user viewed content
  device.browser_version,
  -- The browser in which the user viewed content
  device.web_info.browser AS web_browser,
  -- The version of the browser in which the user viewed content
  device.web_info.browser_version AS web_browser_version,
  -- The hostname associated with the logged event
  device.web_info.hostname
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,
  7,
  8,
  9,
  10,
  11,
  12,
  13,
  14,
  15,
  16,
  17
LIMIT
  10