$1.$

Use the

s

alesordersDB

database schema

$.$

$2$

$.$

Translate the requirement

s

b

elow into

a

SQL

query

that accomplishes the following:

$-$

a$.$Management is concerned that customer

s

$10$

$07,1012,$ and $1014$ are

purchasing beyond

the agreed limit$.$ They have requested output showing each purchase transaction by

each

customer.

$.$

Make sure it

looks exactly like the example output $($at the back of this

assignment$).$ Hint:

$504$

rows returned.

Required sql constructs: Table JOINs.