1.Display the seating capacity, fuel capacity, and miles per gallon for all aircraft manufactured by Boeing. Information about each equipment type should be displayed only once.I have tried this:SELECT EQUIP_TYPE.EQ_SEAT_CAPACITY, EQUIP_TYPE.EQ_FUEL_CAPACITY, EQUIP_TYPE.EQ_miles_per_galFROM EQUIP_TYPEWHERE EQ_EQUIP_NO IN (SELECT MIn( EQ_EQUIP_NO) FROM EQUIP_TYPE where EQ_EQUIP_TYPE LIKE 'BOE%' GROUP BY EQ_EQUIP_TYPE)However it returns the query back empty. I am unsure where i went wrong. Relationships XRESERVATIONRES CONFIRM_NORES_DATERES_FNAMERES_LNAMERES_PHONERES_FLIGHT_NORES_FLIGHT DATEAIRPORT TABLEair_codeair_locationair_elevationair_phoneair_hub_airlineEQUIP_TYPEEQ EQUIP_NOEQ_EQUIP_TYPEEQ SEAT CAPACITYEQ FUEL CAPACITYEQ_miles_per_galFLIGHT TABLEfl_flight_nofl_origfl_destfl_orig_timefl_dest_timefl_mealfl_farefl_distance.fl_time_zones00DEPARTURESDEP FLIGHT_NODEP_DEP_DATEDEP_PILOT_IDDEP_EQUIP_NOTICKETTIC ITINERARY_NOTIC FLIGHT NOTIC FLIGHT DATETIC_SEAT18PILOT TABLEpil pilot_idpil pilot Fnamepil_pilot_Lnamepil_ssnpil_streetpil_citypil_statepil_zippil_flight_paypil_brthdatepil_hiredatePASSENGERPAS FNAMEPAS LNAMEPAS ITINERARY_NOPAS FAREPAS_CONFIRM_NO

The correct answer is given below with an explanation. I cannot attach the output as I don't have…

Answered: .Display the seating capacity, fuel…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

100%

1.Display the seating capacity, fuel capacity, and miles per gallon for all aircraft manufactured by Boeing. Information about each equipment type should be displayed only once.

I have tried this:

SELECT EQUIP_TYPE.EQ_SEAT_CAPACITY, EQUIP_TYPE.EQ_FUEL_CAPACITY, EQUIP_TYPE.EQ_miles_per_gal
FROM EQUIP_TYPE
WHERE EQ_EQUIP_NO IN (SELECT MIn( EQ_EQUIP_NO)
FROM EQUIP_TYPE where EQ_EQUIP_TYPE LIKE 'BOE%' GROUP BY
EQ_EQUIP_TYPE)

However it returns the query back empty. I am unsure where i went wrong.

Relationships X
RESERVATION
RES CONFIRM_NO
RES_DATE
RES_FNAME
RES_LNAME
RES_PHONE
RES_FLIGHT_NO
RES_FLIGHT DATE
AIRPORT TABLE
air_code
air_location
air_elevation
air_phone
air_hub_airline
EQUIP_TYPE
EQ EQUIP_NO
EQ_EQUIP_TYPE
EQ SEAT CAPACITY
EQ FUEL CAPACITY
EQ_miles_per_gal
FLIGHT TABLE
fl_flight_no
fl_orig
fl_dest
fl_orig_time
fl_dest_time
fl_meal
fl_fare
fl_distance.
fl_time_zones
00
DEPARTURES
DEP FLIGHT_NO
DEP_DEP_DATE
DEP_PILOT_ID
DEP_EQUIP_NO
TICKET
TIC ITINERARY_NO
TIC FLIGHT NO
TIC FLIGHT DATE
TIC_SEAT
18
PILOT TABLE
pil pilot_id
pil pilot Fname
pil_pilot_Lname
pil_ssn
pil_street
pil_city
pil_state
pil_zip
pil_flight_pay
pil_brthdate
pil_hiredate
PASSENGER
PAS FNAME
PAS LNAME
PAS ITINERARY_NO
PAS FARE
PAS_CONFIRM_NO

Expert Solution

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions