Intuit Interview Question

Asked a few questions regarding joins.