Compunnel interview question

SQL Joins, function differences, nested