Exercise

Working out in the big city

Being one of the most popular data types in Snowflake, text data is often used within a query itself for things like CASE statements, WHERE clauses, and more!

You'll supplement a query that retrieves information about premium gym locations and classifies them as located in a major or non-major city. Keep a close eye on those text values!

Instructions

100 XP

In the CASE statement, update the first value in parentheses to be New York.
After the else keyword, add the string Non-Major City; this is the value that will be returned if the condition above does not match.
Update the WHERE clause to only return records with a gym_type of 'Premium'.

.css-6su6fj{-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;}Exercise

Instructions

Exercise