Deloitte interview question

Basic questions on SQL and joins