ZS Associates Interview Question

SQL queries on joins, describe yourself, two puzzles/guestimates.