Leetcode Problem 1294. Weather Type in Each Country

1294. Weather Type in Each Country

Leetcode Solutions

Calculating Weather Type Based on Average Weather State

Filter the Weather table to include only entries from November 2019.
Calculate the average weather_state for each country_id within the filtered date range.
Use a CASE statement to categorize the average weather state into 'Cold', 'Hot', or 'Warm'.
Join the resulting table with the Countries table to get the corresponding country_name for each country_id.
Select the country_name and the determined weather_type for the final output.
Ensure the query groups the results by country_id to calculate the average weather state per country.

erDiagram
    Countries {
        int country_id PK
        varchar country_name
    }
    Weather {
        int country_id PK
        int weather_state
        date day PK
    }
    Countries ||--o{ Weather : has

Using Subquery to Calculate Average Weather State

Ask Question

Programming Language

Purpose:

General Question

Debug My Code

image/screenshot of info(optional)

Full Screen

Leetcode Problem 1294. Weather Type in Each Country

Leetcode Solutions

Calculating Weather Type Based on Average Weather State

Solution Idea

Query Steps

Code Implementation

Using Subquery to Calculate Average Weather State

Ask Question

Suggested Answer