I am on question 6 in which it asks you to return a rank of the coldest temperatures on record. I am not sure why my query isn’t returning any results:
SELECT state, year, tempc,
RANK() OVER (ORDER BY temp_c) AS ‘coldest_rank’
Would someone be able to help? The question does not want the data to be partitioned by state or year.