A company tracks the performance of its sales representatives in a table with columns: 'Rep Name', 'Region', 'Total Sales (USD)', 'Number of Deals', and 'Customer Satisfaction Rating (1-5)'. Which of the following queries would identify all sales representatives who achieved 'Excellent' customer satisfaction (rating of 5) but closed fewer than 10 deals?
✓ Correct Answer: Option C
To find reps with a rating of 5 AND fewer than 10 deals, both conditions must be met simultaneously. 'Excellent' rating (5) AND 'fewer than 10 deals' (<10) directly translates to option C.