My issue
SELECT * FROM ORDERS
WHERE DELAY_TIME > 10 AND
ORDER_DATE IN (‘5TH APRIL’,‘4TH APRIL’,‘6th APRIL’);
IT IS CORRECT BUT NOT ACCEPT HERE WHY??
My code
/* Write a query to output the following
- Output all entries for 4th, 5th, 6th April for delayed orders
- Any order where delay time $\gt$ 10 minutes is considered as a delayed order */
SELECT * FROM ORDERS
WHERE DELAY_TIME > 10 AND
ORDER_DATE IN ('5TH APRIL','4TH APRIL','6th APRIL');
Learning course: SQL at Work
Problem Link: CodeChef: Practical coding for everyone