Compunnel Interview Question

SQL Joins, function differences, nested