ZS Associates Interview Question

Different SQL queries and their theory.