Queries for Intermediate level

I wrote a query for the intermediate level (and followed the corresponding course)