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

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. Display client ID, suburb and phone in descending order of suburb.
  1. Display all 2020 orders from the Order table

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!