SQL Taskbook Level 3.10
Given a table:
| id | shipment_id | total | status | date | country |
| 1 | 13122 | 5.55 | In Progress | 2023-09-27 | China |
| 2 | 54543 | 5.00 | Completed | 2023-09-07 | China |
| 3 | 43123 | 4.60 | In Progress | 2023-09-09 | USA |
| 4 | 32342 | 5.00 | In Progress | 2023-09-01 | USA |
| 5 | 32431 | 5.55 | Completed | 2023-09-05 | China |
| 6 | 1231 | 5.55 | In Progress | 2023-10-07 | USA |
Solve the following tasks for it:
List shipments that have a ship date in the current month and a shipping cost greater than 5 dollars. Include the shipment number, ship date, and shipping cost.
Find shipments where the shipping cost is greater than 5 dollars, the ship date was before the current date, and the shipping number starts with 1. Provide the shipment number and shipping cost.
Display shipments where the shipping country is not 'USA' and the shipping cost is less than 5 dollars and the ship date was in the current year. Include the shipment number, shipping country, and shipping cost.
Find shipments with a status of 'In progress' and a ship date of more than 30 days ago and a shipping cost greater than 5 dollars. Provide the shipment number and shipping cost.
Display shipments with shipping costs in the 10% highest shipping costs and a ship date in the current year. Provide the shipment number and shipping cost.