State Street Interview Question

Diff between joints and subqueries and NVL function