COMPLETE: CASE Statements
Scenario: Your initial ridership research is met with great enthusiasm. This enthusiasm resulted in a
follow-up request. For the next phase of your report, please provide one SQL CASE statement that labels
cities by ridership using the conditions detailed below.
Note: You have access to the data table Ridership_Total, which includes the City and Ridership_Amount columns. You can use the create
table statement in this file to create the table and test out your queries in DB Fiddle.
Conditions SQL Statement
If a city has under 5000 riders, the "heat
label" for that city should be: "Cold"
If a city has between 5000 and 10000 riders,
the "heat label" for that city should be:
"Warm"
If a city has between 10000 and 20000 riders,
the "heat label" for that city should be: "Hot"
If a city has over 20000 riders, the "heat
label" for that city should be: "Fire"