RippleHire interview question

3 join sql query , database schema