Question: Answer the following questions based on the CLIENT and ORDER tables: CLIENT ClientId LastName FirstName Suburb Phone City 1 Jason Rita Bella Boulevard 3432422 Sydney
Answer the following questions based on the CLIENT and ORDER tables:
CLIENT
| ClientId | LastName | FirstName | Suburb | Phone | City |
| 1 | Jason | Rita | Bella Boulevard | 3432422 | Sydney |
| 2 | Smith | Jackson | HighPark | 5535333 | Sydney |
| 3 | Wagner | James | Richmond | 4425253 | Perth |
| 4 | Blake | Susan | Rockdale | 5141412 | Brisbane |
| 5 | Jones | Tania | Como | 5474574 | Melbourne |
| 6 | Lynn | Karina | Dural | 1231241 | Sydney |
| 7 | Walters | Max | HighPark | 4574774 | Perth |
| 8 | Poplar | Liam | Crasspark | 1312425 | Brisbane |
| 9 | Robb | Noah | Elwood | 6746236 | Melbourne |
| 10 | Henlon | James | Hawthrone | 1235636 | Darwin |
ORDER
| OrderNo | OrderDesc | ClientId | OrderDate | ShippedDate | Country | Total Amount |
| 17895 | Large Item | 3 | 12/10/18 | 16/10/18 | Australia | 200.50 |
| 21678 | Small Item | 2 | 05/01/19 | 09/01/19 | Italy | 300.00 |
| 22456 | Item ABC | 4 | 10/03/19 | 12/03/19 | France | 400.75 |
| 24562 | Medium Item | 2 | 26/12/19 | 27/12/19 | Australia | 150.00 |
| 34764 | 3 Tier Design | 5 | 18/07/20 | 20/07/20 | Japan | 370.60 |
| 36533 | Round Box | 8 | 22/09/20 | 27/09/20 | Australia | 190.85 |
| 36536 | Brand-005 | 3 | 22/09/20 | 24/09/20 | China | 216.75 |
| 37454 | Express Delivery | 1 | 11/11/20 | 14/11/20 | Denmark | 625.00 |
- Write SQL statements to fulfil the following requirements and provide the screenshot of the output:
- Display names of all countries in ascending where orders have been shipped.
- Display Order Id and Order Description, order date for all orders that were placed in September 2020. Display results in ascending order of orderId.
- Display highest amount of order total placed in year 2020.
- Display orderID, Order Description, Client ID and Client Name related to all orders placed in month of December or order description has Box word in it.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
