Subqueries in Select Clauses

I don’t understand what I’m missing in this query to get the result. Hard time getting my head around these subqueries.

What is your question? Are you wondering about the error marker in line 9? That’s probably because you didn’t end the first query from line 1 to 7 with a semicolon.

Thanks Sam. I’m always over looking simple stuff. The further i get in this course the more lost I am. Not enough excercises to drill this stuff in my head. Any advice on where to find more examples to work through.