Pergunta de entrevista da empresa OPEXUS

Gave two simple tables and asked to write sql to select certain attributes that required joining.