Question

Table name: information
id
City
MaxTemp
MinTemp
RainFall
C1
Delhi
40
32
24.1
C2
Bengaluru
31
25
36.2
C3
Chennai
35
27
40.8
C4
Mumbai
29
21
35.2
C5
Kolkata
39
23
41.8
Write a query to create this table using appropriate datatype
Write a query to display the name of city name without repetition.
Write a query to decrease the temperature of cities by 1 degree permanently
Write a query to display the information where min temperature is > 30
Write a query to display records where rainfall > 40 or max temperature > 38​

Answer 1

Explanation:

35.2

C5

Kolkata

39

23

41.8

Write a query to create this table using appropriate datatype

Write a query to display the name of city name without repetition.

Write a query to decrease the temperature of cities by 1 degree permanently

Write a query to display the information where min temperature is > 30

Write a query to display records where rainfall > 40 or max temperature > 38