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

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)