Advanced SQL Climate Change

Trying to do this project, have no idea what it want me to do. It want’s me to use window functions but makes more sense not too. Why not use MIN() rather than FIRST_VALUE()? FIRST_VALUE gives the temp in 1985 not the lowest_temp.

Had a look at the other topic and there’s a few of us stumbling not knowing what to do.

Can anyone that has done this share or explain how/why you did the steps.