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.

Clientld 1 2 3 4 5 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 Phone 3432422 5535333 4425253 5141412 5474574 1231241 4574774 1312425 6746236 1235636 City Sydney Sydney Perth Brisbane Melbourne Sydney Perth Brisbane Melbourne Darwin 6 7 8 9 10 ORDER Order No Order Desc Clientld Order Date ShippedDate Country 3 2 4 17895 21678 22456 24562 34764 36533 36536 37454 Large Item Small Item Item ABC Medium Item 3 Tier Design Round Box Brand-005 Express Delivery 12/10/18 05/01/19 10/03/19 26/12/19 18/07/20 22/09/20 22/09/20 11/11/20 2 5 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 8 3 1