Company: amdocs_1april
Difficulty: easy
Problem Description Write an SQL query to retrieve all details for orders that have been successfully shipped. Specifically, your query should select all records from the orders table where the order_status is exactly 'Shipped' . Schema Table: orders Column Name Data Type Description order_id Integer The unique identifier for each order. customer_id Integer The identifier for the customer who placed the order. order_status Varchar The current status of the order (e.g., 'Pending', 'Shipped', 'Delivered'). order_total Decimal The total monetary value of the order. Required Output The result set should include all columns from the orders table in the following order: order_id customer_id order_status order_total The results should be sorted by order_id in ascending order. Constraints or Notes The filter condition 'Shipped' is case-sensitive. The query should return all matching rows. If no rows match, return an empty result set. Standard SQL syntax should be used. Examples Input: orders t