Telemetry/LongitudinalExamples: Difference between revisions

Simplifying examples
(added some blocklist examples)
(Simplifying examples)
Line 28: Line 28:
  SELECT bl, COUNT(bl)
  SELECT bl, COUNT(bl)
  FROM
  FROM
   (SELECT client_id,
   (SELECT element_at(settings, 1).user_prefs['extensions.blocklist.url'] AS bl
          element_at(settings, 1).user_prefs['extensions.blocklist.url'] AS bl
     FROM longitudinal_v20160229)
     FROM longitudinal_v20160229)
  GROUP BY bl
  GROUP BY bl
Line 36: Line 35:
  SELECT bl, COUNT(bl)
  SELECT bl, COUNT(bl)
  FROM
  FROM
   (SELECT client_id,
   (SELECT element_at(settings, 1).blocklist_enabled AS bl
          element_at(settings, 1).blocklist_enabled AS bl
     FROM longitudinal_v20160229)
     FROM longitudinal_v20160229)
  GROUP BY bl
  GROUP BY bl
Confirmed users
95

edits