Climate Classification by Country
For each country determine its weather type for November 2019: Cold if average <= 15, Hot if average >= 25, Warm otherwise. Return country_name and weather_type.
Expected output sample
This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables.
| country_name | weather_type |
|---|---|
| Egypt | Hot |
| France | Cold |
| Italy | Warm |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign in