NetApp interview question

quite simple SQL query up to JOIN level