Meta Interview Question

some sql question dealing with join func