Examlex

Solved

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

question 50

Multiple Choice

CUSTOMER
 Cname  Age  Resid_City  BirthPlace  BLACK 40 ERIE  TAMPA  GREEN 25 CARY  ERIE  JONES 30 HEMET  TAMPA  MARTIN 35 HEMET  TAMPA  SIMON 22 ERIE  ERIE  VERNON 60 CARY  CARY \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
 Cname  Make  Date_Out  Pickup  Return  Rtn  BLACK  FORD 10 Oct-1994  CARY  CARY 1 BLACK  GM 01 Nov-1995  TAMPA  CARY 2 BLACK  FORD 01Jan1995 ERIE  ERIE 3 GREEN  NISSAN 07Jul1994 TAMPA  TAMPA 4 JONES  FORD 01Jul1995 CARY  ERIE 5 JONES  GM 01Aug1995 ERIE  ERIE 6 MARTIN  FORD 01Aug1994 CARY  ERIE 7 SIMON  GM 01Sep1995 ERIE  CARY 8 WARP  TOYOTA 02Sep1995 RENO  RENO 9\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
 MAKE  COST  FORD 30 GM 40 NISSAN 30 TOYOTA 20 VOLVO 50\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
 CITY  FACTOR  CARY 1 ERIE 1.1 RENO 0.9 TAMPA 0.8\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
 RTN  DAYS 1123324254627381\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 MIN(Age) AS Minage,MAX(Age) AS Maxage
FROM CUSTOMER
GROUP BY Resid_City,BirthPlace
Which one of the following values does not appear in the column with heading Minage?


Definitions:

Federal Question Jurisdiction

This refers to the authority of United States federal courts to hear cases that involve federal laws, the U.S. Constitution, or treaties.

Original Jurisdiction

The power to decide a case as a trial court.

Diversity Jurisdiction

A principle in federal jurisdiction in the United States allowing federal courts to hear lawsuits involving parties from different states or countries where the matter in controversy exceeds a statutory amount.

Exclusive Jurisdiction

The sole authority of a particular court or legal body to hear and decide on cases within a specific area of law or geographic location.

Related Questions