Data Science | Cumulative SQL Project

Hello everyone,

Is it me or does this exercise require using SQL commands which have not been taught in any of the lessons which have been before it. Am I missing something?

I agree, I have really been puzzled by quite a few of these problems. I’m doing final project and am completely confused