Deloitte interview question

Some SQL questions on joins