SQL Window Functions (Climate change task)

https://www.codecademy.com/paths/analyze-data-with-sql/tracks/advanced-sql/modules/sql-window-functions/projects/sql-window-functions-project

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’
FROM state_climate;

Would someone be able to help? The question does not want the data to be partitioned by state or year.

I believe the name of the column is tempc (without an underscore). You wrote temp_c in your ORDER BY :slightly_smiling_face:

2 Likes

This topic was automatically closed 41 days after the last reply. New replies are no longer allowed.