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.
Types of Loop
Loops are the elements of programming in which a part of code is repeated a particular number of times. Loop executes the series of statements many times till the conditional statement becomes false.
Loops
Any task which is repeated more than one time is called a loop. Basically, loops can be divided into three types as while, do-while and for loop. There are so many programming languages like C, C++, JAVA, PYTHON, and many more where looping statements can be used for repetitive execution.
While Loop
Loop is a feature in the programming language. It helps us to execute a set of instructions regularly. The block of code executes until some conditions provided within that Loop are true.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images