Skip to content

Instantly share code, notes, and snippets.

@erchn

erchn/fizzbuzz.sql

Last active October 15, 2018 21:50
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 erchn/5f8cc509b4f9b55371d2c2e2c3f35994 to your computer and use it in GitHub Desktop.
Save erchn/5f8cc509b4f9b55371d2c2e2c3f35994 to your computer and use it in GitHub Desktop.
Download ZIP
Athena FizzBuzz
Raw
fizzbuzz.sql
SELECT val,
CASE
WHEN by5+by3 = 0 THEN 'FizzBuzz'
WHEN by5 = 0 THEN 'Fizz'
WHEN by3 = 0 THEN 'Buzz'
ELSE cast(val AS varchar)
END AS fizzbuzz_test
FROM
(SELECT val,
mod(val, 5) AS by5,
mod(val, 3) AS by3
FROM (values (15), (10), (9), (17)) AS t (val));
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment