Consider the Following Relational Database for Grand Travel Airlines$$\begin{array} { | l | l | l | l | }
\hline \text { PLOTNUM } & \text { PILOTNAME } & \text { BIRTHDATE } & \text { HIREDATE } \
\hline
\end{array}$$

Question

Consider the Following Relational Database for Grand Travel Airlines$$\begin{array} { | l | l | l | l | } 
\hline \text { PLOTNUM } & \text { PILOTNAME } & \text { BIRTHDATE } & \text { HIREDATE } \
\hline
\end{array}$$

Examlex · Accepted Answer

The Answer is a. SELECT *
FROM AIRPLANE
WHERE MANUF='Boeing';

b. SELECT COUNT(*)
FROM RESERVATION
WHERE FLIGHTNUM=278
AND DATE='FEB-21-2004;

c. SELECT DISTINCT FLIGHTNUM
FROM FLIGHT
WHERE DATE='MAR-07-2004'
AND (DEPTIME BETWEEN 1000 AND 1059
OR ARRTIME>1500);

d. SELECT COUNT(*)
FROM AIRPLANE
WHERE MANUF='Boeing'
AND MODEL='737';

e. SELECT MODEL, COUNT(*)
FROM AIRPLANE
WHERE MANUF='Boeing'
GROUP BY MODEL;

f. SELECT PILOTNAME, HIREDATE
FROM PILOT, FLIGHT, AIRPLANE
WHERE PILOT.PILOTNUM=FLIGHT.PILOTNUM
AND FLIGHT.PLANENUM=AIRPLANE.PLANENUM
AND MANUF='Airbus'
AND MODEL='A320'
AND DATE BETWEEN 'MAR-01-2004' AND 'MAR-31-2004';

g. SELECT PASSNAME, ADDRESS, PHONE
FROM PASSENGER, RESERVATION
WHERE PASSENGER.PASSNUM=RESERVATION.PASSNUM
AND FLIGHTNUM=562
AND DATE='JAN-15-2004';

h. SELECT FLIGHT.FLIGHTNUM, SUM(FARE)
FROM FLIGHT, RESERVATION
WHERE FLIGHT.FLIGHTNUM=RESERVATION.FLIGHTNUM
AND FLIGHT.DATE=RESERVATION.DATE
AND RESERVATION.DATE='DEC-23-2003'
AND DEPTIME BETWEEN 900 AND 1000
GROUP BY FLIGHT.FLIGHTNUM
HAVING SUM(FARE)>=5000;

i. SELECT PLANENUM
FROM AIRPLANE
WHERE MANUF='Boeing'
AND MODEL='737'
AND CAPACITY=
(SELECT MIN(CAPACITY)
FROM AIRPLANE
WHERE MANUF='Boeing'
AND MODEL='737');

j. SELECT PLANENUM
FROM AIRPLANE
WHERE MANUF='Airbus'
AND MODEL='A310'
AND CAPACITY>
(SELECT MIN(CAPACITY)
FROM AIRPLANE
WHERE MANUF='Boeing'
AND MODEL='737');

Consider the Following Relational Database for Grand Travel Airlines $\begin{array} { | l | l | l | l | } \hline \text { PLOTNUM } & \text { PILOTNAME } & \text { BIRTHDATE } & \text { HIREDATE } \\\hline\end{array}$

Definitions: