LATERAL SUBQUERY is a subquery that is preceded by the keyword LATERAL. It provides a way to reference columns in the preceding FROM clause. Without the LATERAL keyword, subqueries can only refer to ...

Problem The bug.sql file contains a SQL query that attempts to count the number of orders for each customer. The subquery counts orders per customer, but it lacks an alias, leading to a syntax error.