Skip to content

Instantly share code, notes, and snippets.

@WashingtonGold

WashingtonGold/sql2.sql

Last active August 9, 2020 16:30
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 WashingtonGold/3e51fef7671b7f5e3b1a272cb1aa6e2e to your computer and use it in GitHub Desktop.
Save WashingtonGold/3e51fef7671b7f5e3b1a272cb1aa6e2e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
sql2.sql
SELECT Price,
CASE WHEN Price < 12 THEN 'Cheap'
WHEN Price < 21 THEN 'Regular'
ELSE 'Expensive'
END AS Bucket
FROM Products
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment