Q. Find the error in the following MySQL statement?
SELECT cust_id, fed_id
FROM customer
WHERE cust_id = ’I’
AND fed_id BETWEEN 5000-00-000 AND 9999-999-000;
SELECT cust_id, fed_id
FROM customer
WHERE cust_id = ’I’
AND fed_id BETWEEN 5000-00-000 AND 9999-999-000;
✅ Correct Answer: (B)
No
Explanation: This question tests your understanding of how to use the WHERE clause in MySQL, specifically when working with numeric data. Let's break down the code and find the error: