Brillio Interview Question

Basic SQL questions on joins