Brillio interview question

Basic SQL questions on joins