1. What constraint must a scalar subquery satisfy?
- It must reference at least two tables.
- It must return exactly one column and at most one row.
- It must run in less than 100ms.
- It must not contain a WHERE clause.
Hint: Scalar subqueries return a single value. If they return multiple rows or columns, SQL throws a cardinality violation error.