SQL packet processing meteorological data and precautions

problem: from all meteorological stations nationwide data climatic data table (temperature, precipitation, wind speed, etc.) to find the station and meteorological information in the study area.

Solve:

Select station number as station number, year as year, precipitation as precipitation, average as average temperature from site climate year data where  station number in (select station number from study area site) and year in (select Dist INCT (year) from Research area site) Group by station number, year, precipitation, average temperature order by station number, year

Note: If you have groups, the columns of the query must be in the grouping!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! (That is, you cannot write a group by station number).

SQL packet processing meteorological data and precautions