shiny-kernels.sql

SELECT shiny,
       count(1) AS hits
FROM
  (SELECT (CASE WHEN (kernel LIKE '%-generic%'
                      OR kernel LIKE '%-lowlatency%'
                      OR kernel LIKE '%.fc%')
           AND NOT kernel LIKE '3.2.%' THEN 'Yay' ELSE 'Nope' END) AS shiny
   FROM
     (SELECT submission_date[1] as date, system_os[1].version AS kernel
      FROM telemetry.longitudinal
      WHERE os = 'Linux')
   WHERE date > '2017-05-20')
GROUP BY shiny