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

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.

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.