Answer the following questions based on the CLIENT and ORDER tables: CLIENT Clientid 1 2 3 LastName Jason Smith Wagner Blake Jones 4 5 6 FirstName Rita Jackson James Susan Tania Karina Max Liam Noah James Suburb Bella Boulevard High Park Richmond Rockdale Como Dural High Park 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 Lynn 7 8 Walters Poplar Robb Henlon 9 10 ORDER Order No Order Desc Clientld Order Date shippedDate Country 3 2 17895 21678 22456 24562 34764 4 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 36533 36536 37454 noom 1 2. Write SQL statements to fulfill the following requirements and provide the screenshot of the output: (7 marks ! a. Display client details in descending order of the client first name. (1 mark) b. Find details of all clients whose last name begins with 'Ja'. Display results in descending order of country. (2 marks) c. Display number of clients living in Sydney. (2 mark) d. Display order Id, client details (name, ID of clients) and country for the orders placed in 2020. Display results in descending order of Qrderd, (2 marks)

FirstName Rita Jackson James Susan Jason Smith Wagner Blake Jones Lynn Walters Poplar Robb Henlon Tania Karina Max Liam Noah Suburb Bella Boulevard High Park Richmond Rockdale Como Dural High Park Crasspark Elwood, Hawthrone Phone City 3432422 Sydney 5535333 Sydney 4425253 Perth 5141412 Brisbane 5474574 Melbourne 1231241 Sydney 4574774 Perth 1312425 Brisbane 6746236 Melbourne 1235636 Darwin James OrderDesc Clientid Order Date wwwwwwwwwwwwww ShippedDate WWWMV wwwwwwwwwww Country ANNA 3 2 4 Large Item Small Item Item ABC Medium Item 3 Tier Design Round Box Brand-005 Express 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 mah Total Amount 200.50 300.00 400.75 150.00 370.60 190.85 216.75 Australia Italy France Australia Japan Australia China ca un SALAT