3forge Interview Question

Gave a Schema and asked a SQL Select