Find the temperature in increasing order of all cities, Table Name 'weather'

A. SELECT city FROM weather ORDER BY temperature;

B. SELECT city, temperature FROM weather;

C. SELECT city, temperature FROM weather ORDER BY temperature;

D. SELECT city, temperature FROM weather ORDER BY city;

Answer: Option C

Solution(By Examveda Team)

To retrieve the temperature of all cities in increasing order, you should use the SQL query SELECT city, temperature FROM weather ORDER BY temperature; (Option C). This query selects both the "city" and "temperature" columns from the "weather" table and arranges the result set in ascending order based on the "temperature" column. As a result, you'll get the temperature values for all cities listed from the lowest to the highest temperature.