Filtering Shipped Orders

Problem Statement

Filtering Shipped Orders An online store records every order in the table orders . Write an SQL query that returns all columns of every order whose order_status is exactly 'Shipped' , sorted by order_id in ascending order. Table: orders Column Data Type Description order_id INTEGER Unique id of the order customer_id INTEGER Id of the customer who placed the order (a customer can have many orders) order_status VARCHAR(20) Current status of the order, for example Pending , Shipped , Delivered , Cancelled order_total DECIMAL(10,2) Total value of the order Expected Output Return all four columns of the table, in this order: Column Description order_id Id of the shipped order customer_id Id of the customer order_status Always Shipped order_total Total value of the order Rules An order qualifies only when order_status is exactly the text Shipped . The comparison is case-sensitive: shipped or SHIPPED do not qualify, and neither does a longer status that merely contains the word, such as Parti