Quiestion $3$

Customer. Emplayce

contact $=$ projedt

Page $6$ of $17$

Consider the following three relations used in a moving truck rental database.

$(14$ marks$)$

Marge

RENTAL$\_$AGENT $($name$,$ age, salary$)$

CUSTOMER $($name$,$ pickup$\_$city, dropoff$\_$city, truck$\_$size$)$

CONTRACT $($number$,$ cust$\_$name, agent$\_$name, amount$\_$paid, truck$\_$number$)$

Write SQL statements to answers the following questions.

a$.$ Display the name of the oldest rental agent.

b$.$ Display the names and ages of the agents who have rented trucks for customer "Chris

Auto" in descending order of age $($use a subquery$).$

c$.$ Display the ages of agents who have rented trucks for customer "Chris Auto" from

"Edmonton" $($do not use a subquery$).\_$empopels

d$.$ Compute the number of different customers who have a rental contract. ${?}^{-}$

e$.$ Display the names and salaries of all rental agents who did not rent trucks for customer

"Chris Auto", in ascending order of salary.

f$.$ Compute the number of contracts for each agent. Consider only those contracts where the

amount paid exceeds $$1000.$

g$.$ Display the names and salaries of all agents who have at least $10$ rental contracts for truck

size $"20$ CU$".$