SmartPay interview question

Do a join on three SQL tables selecting data that meets a given criteria.