NetApp Interview Question

quite simple SQL query up to JOIN level