1. **Produce a list of station name, year, month, wind speed, temperature.** 2. **For each station, find the total number of valid wind reports and the total number of valid temperature reports.** - *Note:* Do not count NULL as a valid report. 3. **For each station, find the total number of wind reports and the total number of temperature reports in each year.** - From the output, identify stations that did not report a valid reading every month. 4. **Find how many wind speed reports are collected in each month? How many temperature reports are collected each month?** 5. **For each station, find the first year at which the station started to report wind speeds and the first year at which the station started to report temperature readings.** 6. **Find the coldest and hottest temperatures for each station.** 7. **What is the maximum and minimum temperatures reported in 2009?** - What are the stations that reported these maximum and minimum temperatures? 8. **What is the average wind speed at 90-degree latitude?** - *Note:* Do not look at the data to find what stations are located at 90-degree latitude, however, you have to use 90 in your query. 9. **The name of the weather station at the South Pole is called Clean Air, because very little man-made pollution can be found there.** - Find out what temperatures were recorded at the South Pole such that the output is sorted by temperatures. When is it Summer and when is it Winter in the South Pole? 10. **For each station, find the maximum, minimum, and average temperature reported in a certain month of the year.** - Comment on when do you think it is Summer and when it is Winter for each station.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question
1. **Produce a list of station name, year, month, wind speed, temperature.**

2. **For each station, find the total number of valid wind reports and the total number of valid temperature reports.** 
   - *Note:* Do not count NULL as a valid report.

3. **For each station, find the total number of wind reports and the total number of temperature reports in each year.** 
   - From the output, identify stations that did not report a valid reading every month.

4. **Find how many wind speed reports are collected in each month? How many temperature reports are collected each month?**

5. **For each station, find the first year at which the station started to report wind speeds and the first year at which the station started to report temperature readings.**

6. **Find the coldest and hottest temperatures for each station.**

7. **What is the maximum and minimum temperatures reported in 2009?** 
   - What are the stations that reported these maximum and minimum temperatures?

8. **What is the average wind speed at 90-degree latitude?** 
   - *Note:* Do not look at the data to find what stations are located at 90-degree latitude, however, you have to use 90 in your query.

9. **The name of the weather station at the South Pole is called Clean Air, because very little man-made pollution can be found there.** 
   - Find out what temperatures were recorded at the South Pole such that the output is sorted by temperatures. When is it Summer and when is it Winter in the South Pole?

10. **For each station, find the maximum, minimum, and average temperature reported in a certain month of the year.** 
    - Comment on when do you think it is Summer and when it is Winter for each station.
Transcribed Image Text:1. **Produce a list of station name, year, month, wind speed, temperature.** 2. **For each station, find the total number of valid wind reports and the total number of valid temperature reports.** - *Note:* Do not count NULL as a valid report. 3. **For each station, find the total number of wind reports and the total number of temperature reports in each year.** - From the output, identify stations that did not report a valid reading every month. 4. **Find how many wind speed reports are collected in each month? How many temperature reports are collected each month?** 5. **For each station, find the first year at which the station started to report wind speeds and the first year at which the station started to report temperature readings.** 6. **Find the coldest and hottest temperatures for each station.** 7. **What is the maximum and minimum temperatures reported in 2009?** - What are the stations that reported these maximum and minimum temperatures? 8. **What is the average wind speed at 90-degree latitude?** - *Note:* Do not look at the data to find what stations are located at 90-degree latitude, however, you have to use 90 in your query. 9. **The name of the weather station at the South Pole is called Clean Air, because very little man-made pollution can be found there.** - Find out what temperatures were recorded at the South Pole such that the output is sorted by temperatures. When is it Summer and when is it Winter in the South Pole? 10. **For each station, find the maximum, minimum, and average temperature reported in a certain month of the year.** - Comment on when do you think it is Summer and when it is Winter for each station.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Types of Loop
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education