RippleHire interview question

Write SQL queries for the following output