CUSTOMER RENTALS In the Table RENTALS, Rtn Provides the Rental Number (The

question 9

Multiple Choice

CUSTOMER
$$\begin{array} { | l | l | l | l | } \hline \text { Cname } & \text { Age } & \text { Resid\_City } & \text { BirthPlace } \\\hline \text { BLACK } & 40 & \text { ERIE } & \text { TAMPA } \\\hline \text { GREEN } & 25 & \text { CARY } & \text { ERIE } \\\hline \text { JONES } & 30 & \text { HEMET } & \text { TAMPA } \\\hline \text { MARTIN } & 35 & \text { HEMET } & \text { TAMPA } \\\hline \text { SIMON } & 22 & \text { ERIE } & \text { ERIE } \\\hline \text { VERNON } & 60 & \text { CARY } & \text { CARY } \\\hline\end{array}$$
RENTALS
$\begin{array}{|l|l|l|l|l|l|}\hline \text { Cname } & \text { Make } & \text { Date\_Out } & \text { Pickup } & \text { Return } & \text { Rtn } \\\hline \text { BLACK } & \text { FORD } & 10-\text { Oct-1994 } & \text { CARY } & \text { CARY } & 1 \\\hline \text { BLACK } & \text { GM } & 01-\text { Nov-1995 } & \text { TAMPA } & \text { CARY } & 2 \\\hline \text { BLACK } & \text { FORD } & 01-J a n-1995 & \text { ERIE } & \text { ERIE } & 3 \\\hline \text { GREEN } & \text { NISSAN } & 07-J u l-1994 & \text { TAMPA } & \text { TAMPA } & 4 \\\hline \text { JONES } & \text { FORD } & 01-J u l-1995 & \text { CARY } & \text { ERIE } & 5 \\\hline \text { JONES } & \text { GM } & 01-A u g-1995 & \text { ERIE } & \text { ERIE } & 6 \\\hline \text { MARTIN } & \text { FORD } & 01-A u g-1994 & \text { CARY } & \text { ERIE } & 7 \\\hline \text { SIMON } & \text { GM } & 01-S e p-1995 & \text { ERIE } & \text { CARY } & 8 \\\hline \text { WARP } & \text { TOYOTA } & 02-S e p-1995 & \text { RENO } & \text { RENO } & 9 \\\hline\end{array}$
In the table RENTALS, Rtn provides the rental number (the primary key., Cname refers to the Cname in Customer, Pickup is the city where the car was picked up, and Return is the city where the car was returned.

RENTCOST
$$\begin{array} { | l | l | } \hline \text { MAKE } & \text { COST } \\\hline \text { FORD } & 30 \\\hline \text { GM } & 40 \\\hline \text { NISSAN } & 30 \\\hline \text { TOYOTA } & 20 \\\hline \text { VOLVO } & 50 \\\hline\end{array}$$
In RENTCOST, COST shows the base cost of renting a given MAKE for one day.

CITYADJ
$$\begin{array} { | l | l | } \hline \text { CITY } & \text { FACTOR } \\\hline \text { CARY } & 1 \\\hline \text { ERIE } & 1.1 \\\hline \text { RENO } & 0.9 \\\hline \text { TAMPA } & 0.8 \\\hline\end{array}$$
If the return city of table RENTALS is the one listed in table CITYADJ, the cost of the rental is multiplied by FACTOR and by DAYS shown in table RENTLENGTH below.

RENTLENGTH
$$\begin{array} { | l | l | } \hline \text { RTN } & \text { DAYS } \\\hline 1 & 1 \\\hline 2 & 3 \\\hline 3 & 2 \\\hline 4 & 2 \\\hline 5 & 4 \\\hline 6 & 2 \\\hline 7 & 3 \\\hline 8 & 1 \\\hline\end{array}$$
RENTLENGTH shows the number of DAYS for the rental number (RTN) of the table RENTALS (this table exists for the sake of testing SQL. Normally, the data here should be part of table RENTALS.
-As a result of the execution of the query SELECT COUNT(*) AS Ct1,AVG(Age) AS Avgage
FROM CUSTOMER
WHERE Resid_City = 'ERIE' OR Resid_City = 'HEMET'
Which one of the following values occurs in the column with heading Avgage?

---

Definitions:

Urethrotrigonitis

An inflammation of the urethra and the trigone area of the bladder, often causing urinary discomfort.

Code Assigned

Refers to a specific identifier given to medical conditions, procedures, or diagnoses in healthcare documentation.

Patient

An individual who is receiving medical care or treatment.

Seventh Characters

Typically refers to the additional digits used in coding systems like ICD-10 to provide more detail about a diagnosis or encounter.