Write a query to fetch all orders with status = 'shipped'.

• A. SELECT * FROM orders WHERE status = 'processing';
• B. SELECT * FROM orders WHERE status = 'pending';
• C. SELECT * FROM orders WHERE status = 'shipped' AND date = '2020-01-01';
• D. SELECT * FROM orders WHERE status = 'shipped';

Answer: (D)

The main idea here is filtering rows with a precise condition using the WHERE clause. To fetch all orders whose status is shipped, you filter by status = 'shipped' and return all columns with SELECT *.

This is the correct approach because it selects every row from the orders table where the status column exactly matches the value 'shipped'. The other options either look for a different status (which would return orders that aren’t shipped) or add an extra date condition, which would exclude shipped orders that don’t meet that date.