Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Answer the following questions based on the CLIENT and ORDER tables: CLIENT Clientid Phone 3 LastName Jason Smith Wagner Blake Jones Lynn Walters Poplar Robb

image text in transcribed

image text in transcribed

Answer the following questions based on the CLIENT and ORDER tables: CLIENT Clientid Phone 3 LastName Jason Smith Wagner Blake Jones Lynn Walters Poplar Robb Henlon FirstName Rita Jackson James Susan Tania Karina Max Liam Noah James Suburb Bella Boulevard HighPark Richmond Rockdale Como Dural HighPark Crasspark Elwood Hawthrone 3432422 5535333 4425253 5141412 5474574 1231241 4574774 1312425 6746236 1235636 City Sydney Sydney Perth Brisbane Melbourne Sydney Perth Brisbane Melbourne Darwin 10 ORDER OrderNo OrderDesc Clientld Order Date ShippedDate Country W 3 2 4 17895 21678 22456 24562 34764 36533 Large Item Small Item Item ABC Medium Item 3 Tier Design Round Box Brand-005 Express Delivery 2 12/10/18 05/01/19 10/03/19 26/12/19 18/07/20 22/09/20 22/09/20 11/11/20 16/10/18 09/01/19 12/03/19 27/12/19 20/07/20 27/09/20 24/09/20 14/11/20 Total Amount 200.50 300.00 400.75 150.00 370.60 190.85 216.75 625.00 Australia Italy France Australia Japan Australia China Denmark 5 8 36536 3 37454 1 2. Write SQL statements to fulfil the following requirements and provide the screenshot of the output: (7 marks ) a. Display client details in Ascending order of the client last name. (1 mark) b. Display first name, last name, suburb of clients who live in the suburbs starting with letter 'H'. (2 marks) C. Display number of clients living in Melbourne. (2 marks) d. Display client name, OrderDesc, Order Date for the orders placed by client with clientID 2. (2 marks) w

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

understand the role of competencies and a competency framework

Answered: 1 week ago

Question

=+Where does the focus of labor relations lie? Is it collective

Answered: 1 week ago

Question

=+With whom does the firm have to negotiate?

Answered: 1 week ago