1. What rows are returned by an INNER JOIN?
- All rows from both tables.
- Only rows where a matching value exists in both tables based on the join condition.
- All rows from the left table, regardless of matches.
- Only unmatched rows.
Hint: INNER JOIN filters out unmatched records from both tables, returning only rows where the join predicate evaluates to TRUE.