Create a file called WeatherData.sql. Create a database called weather and inser

Question

Create a file called WeatherData.sql. Create a database called weather and insert weather data Create a program called WeatherData.java. Write SQL queries on weather data table that return All the records for the city of London All the summer records The city, country, and season for which the average temperature is less than 20 degree The city, country, and season for which the average temperature is greater than 20 degree and the total rainfall is less than 10 mm The maximum total rainfall The city, season, and rainfall amounts for all records in descending order of rainfall The total yearly rainfall for Cairo, Egypt The city name, country and total yearly rainfall for every distinct city

Explanation / Answer

INSERT INTO WEATHER VALUES (/* put accordingly to datatypes*/)

2)

select * from WEATHER where CITY = 'London';

select * from WEATHER where SEASON = 1; // if summer is 1

select CITY, COUNTRY, SEASON from WEATHER where TEMPERATURE < 20.0;

select CITY, COUNTRY, SEASON from WEATHER where TEMPERATURE > 20.0 and RAINFALL < 10.0;

# Only 4 subparts are allowed to answer

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

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