SQL practice: Errors You Will Definitely Hit

This query fails because order_date is neither grouped nor aggregated. Fix it so order_date is aggregated with MAX() as latest_order.

This query fails because WHERE runs before SELECT, so the alias 'limit' doesn't exist yet. Fix the WHERE clause to use the actual column name.

This query fails because the subquery returns multiple customer IDs for Mumbai, but = expects exactly one value. Fix it using IN.

This query accidentally produces a massive Cartesian product because there is no join condition. Fix it with a proper INNER JOIN on customer_id.

This query fails with 'column emial does not exist'. Fix the spelling of email.

This query fails because customer_id exists in both tables, making the column reference ambiguous. Qualify customer_id with orders.