File: select_if.sql

package info (click to toggle)

sqlfluff 3.5.0-2

links: PTS, VCS
area: main
in suites: forky, sid
size: 34,000 kB
sloc: python: 106,131; sql: 34,188; makefile: 52; sh: 8

file content (17 lines) | stat: -rw-r--r-- 423 bytes

parent folder | download | duplicates (3)

SELECT
  client, firstHtml, vary,
  IF(_cdn_provider != '', 'CDN', 'Origin') AS source,
  COUNT(0) AS total
FROM
  `httparchive.almanac.requests`,
  UNNEST(split(REGEXP_REPLACE(REGEXP_REPLACE(LOWER(resp_vary), '\"', ''), '[, ]+|\\\\0', ','), ',')) AS vary
WHERE
  date = '2019-07-01'
GROUP BY
  client, firstHtml, vary, source
HAVING
  vary != '' AND vary IS NOT NULL
ORDER BY
  client DESC,
  firstHtml DESC,
  total DESC