JITpay interview question

Data base select query with join