What is your experience with SQL, and can you write a query to extract specific data?
Use the provided orders table. Write a query that returns completed orders with an amount greater than 100.
order_id, customer_name, amount, and order_dateamount descending, with order_id ascending as the tie-breaker| Column | Type | Description |
|---|---|---|
| order_idPK | INT | Unique order identifier |
| customer_name | VARCHAR(100) | Customer name |
| status | VARCHAR(20) | Order status |
| amount | DECIMAL(10,2) | Order amount |
| order_date | DATE | Date the order was placed |