OneAdvanced Interview Question

SQL Query on Customer table with subquery