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	High Park	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	High Park	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

Questions:

1. Write CREATE and INSERT statements for the above tables and identify constraints. Make sure that primary key, foreign key, not null and other constraints are included in the table creation scripts. (3 marks)

2. Write SQL statements to fulfill the following requirements and provide the screenshot of the output: (7 marks )

1. Display client details in descending order of the client first name. (1 mark)
2. Find details of all clients whose last name begins with Ja. Display results in descending order of country. (2 marks)
3. Display number of clients living in Sydney. (2 marks)
4. Display order Id , client details (name, ID of clients) and country for the orders placed in 2020. Display results in descending order of OrderID. (2 marks)