cenario: 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 utilizing the conditions detailed below.

ConditionsSQL StatementIf a city has under 5000 riders, the heat label for that city should be: ColdIf a city has between 5000 and 10000 riders, the heat label for that city should be: WarmIf a city has between 10000 and 20000 riders, the heat label for that city should be: HotIf a city has over 20000 riders, the heat label for that city should be: Fire