我使用的是MySQL而不是SQL Server

I'm doing an assignment which I tried to complete in SQL Server, as that's the language I will be using at my new job. I completed my query like this:I'm doing an assignment which I tried to comple