What is the difference in average temperatures for each season for CityA vs CityB? SQL Question: For
Question:
What is the difference in average temperatures for each season for CityA vs CityB?
SQL Question:
For this problem, use the following seasons:
Winter - Dec, Jan, Feb
Spring - Mar, Apr, May
Summer - Jun, Jul, Aug
Fall - Sep, Oct, Nov
Compute the average temperature (sum all temperatures in the time period and divide by the number of readings) for each season for CityA and CityB.
Both CityA and CityB datasets have the same schema:
Year INT, Month INT, Day INT, TimeCST INT, TemperatureF INT, DewPointF INT, Humidity INT, SeaLevelPressureIn INT, VisibilityMPH INT, WindDirection STRING, WindSpeedMPH STRING, GustSpeedMPH INT, PrecipitationIn INT, Events STRING, Conditions STRING, WindDirDegrees INT
Statistics Informed Decisions Using Data
ISBN: 9780134133539
5th Edition
Authors: Michael Sullivan III