FizzBuzz SQL Assessment | Dataford Interview Questions

How would you write a SQL query that returns numbers with FizzBuzz rules (multiples of 3 and 5) for a given range?

Write a query against a numbers table that returns each value in the requested range with its FizzBuzz label. Treat the range as inclusive, and ignore any rows where the number is NULL.

Output

One row per qualifying number in the range
Columns: number, fizzbuzz_value
fizzbuzz_value must be FizzBuzz for multiples of 15, Fizz for multiples of 3, Buzz for multiples of 5, and the number itself as text otherwise
Sort by number ascending

Schema

numbers

Column	Type	Description
number	INT	Integer value to evaluate with FizzBuzz rules

Your question is FizzBuzz SQL Assessment. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem