Pregunta de entrevista de RippleHire

Write SQL queries for the following output