zypmedia Interview Question

SQL question using join function