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

Questions:

1. Write CREATE and INSERT statements for the above tables and identify constraints. Make sure primary key, foreign key, not null and other constraints are included in table creation scripts.
2. Write SQL statements to fulfil the following requirements and provide the screenshot of the output:

1. Display client ID, suburb and phone in descending order of suburb.
2. Display all 2020 orders from the Order table
3. Display which country got how many orders in the order_table. Only provide counts with a number greater than 1.
4. Display order date and shipping date along with phone, city and country related to all orders placed between July and November 2020