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

question 62

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.
-The execution of the query SELECT Cname,COUNT (Make) AS COUNT1,
COUNT (DISTINCT Make) AS COUNT2
FROM RENTALS
GROUP BY Cname
Will produce the following number of columns:

---

Definitions:

Airline Industry

A sector comprising companies that provide air transport services for traveling passengers and freight.

Monopolistically Competitive

A market structure characterized by many firms selling products that are similar but slightly differentiated, leading to non-price competition.

Automobile Industry

A global sector that involves the manufacturing, marketing, and selling of motor vehicles.

Advertising

The action of calling public attention to products, services, needs, etc., especially by paid announcements in print, broadcast, or online media.