Skip to content

Instantly share code, notes, and snippets.

@Goryudyuma

Goryudyuma/QUERY3.sql

Created February 28, 2018 07:39
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Goryudyuma/34bd3c2b8d90a2a09c42868be320bd20 to your computer and use it in GitHub Desktop.
Save Goryudyuma/34bd3c2b8d90a2a09c42868be320bd20 to your computer and use it in GitHub Desktop.
Download ZIP
MISQUERY ONLINE
Raw
QUERY3.sql
SELECT n,
CASE
WHEN n % 15 = 0 THEN 'FizzBuzz'
WHEN n % 3 = 0 THEN 'Fizz'
WHEN n % 5 = 0 THEN 'Buzz'
ELSE CAST(n AS text)
END AS f
FROM
GENERATE_SERIES(
(SELECT a FROM tbl),
(SELECT b FROM tbl)) AS tmp(n);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment