Need python help please, cant figure out the following, i need a running script.

Question

Need python help please, cant figure out the following, i need a running script. Thanks for your time and effort

(a) All the records for the city of London

(b) The city, country, and season for which the average temperature is less than 20?

(c) The maximum total rainfall

(d) The city, season, and rainfall amounts for all records in descending order of rainfall

Figure 12.16 A world weather database fragment. Shown are the 24-hour average temperature (in degrees Celsius) and total rainfall amount (in millimeters) for Winter (1), Spring (2), Summer (3), and Fall (4) for several world cities City Mumbai Mumbai Mumbai Mumbai London London London London Cairo Cairo Cairo Cairo Country India India India India United Kingdom United Kingdom United Kingdom United Kingdom Egypt Egypt Egypt Egypt Season Temperature Rainfall 5.9 16.2 24.8 28.4 27.9 1549.4 27.6346.0 4 4.2 207.7 8.3 15.7 0.4 218.5 13.6 20.7 27.7 22.2 169.6 157.0 4 16.5 6.5 4 4.5

Explanation / Answer

(a). Select * from WeatherData wher city='London';

(b). Select City, Country, Season from WeatherData group by City Having avg(Temperature)<20;

(c). Select max(Rainfall) from WeatherData group by City Having sum(Rainfall);

(d). Select City, Season, Rainfall from WeatherData order by Rainfall Desc;

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.