ccording to tables below, write 4 SELECT statements to exemplify nested and/or correlated nested queries
ccording to tables below, write 4 SELECT statements to exemplify nested and/or correlated nested queries
Chapter7: Developing An Excel Application
Section: Chapter Questions
Problem 3RA
Related questions
Question
According to tables below, write 4 SELECT statements to exemplify nested and/or correlated nested queries.
![COMPANY
Company name
AIRLINE_COMPANY
Сompany_name
AIRPLANE_COMPANY
Company name
AIRPORT
Airport code
Airport_name
City
State
FLIGHT
Flight number
Company_name
Weekdays
FLIGHT_LEG
Flight number
Leg number Departure_airport_code Arival_airport_code Scheduled_departure_time Scheduled_arrival_time
Mileage
LEG_INSTANCE
Elight_number
Leg number
Elight date
Departure_airport_code Arrival_airport_code
Number_of_available_seats
Airplane_ID Departure_time Arrival_time
FARE
Flight_number
Fare code
Amount
Restrictions
AIRPLANE
Airplane ID
Max_Seats Airplane type_name
Company_name
CAN LAND
Airplane ID
Airport code](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Ff2971d27-1e1b-48bb-8864-17c0c6f6f8a2%2F0f517347-d86e-49fd-9d19-93850af8d56f%2F0yqc60y_processed.png&w=3840&q=75)
Transcribed Image Text:COMPANY
Company name
AIRLINE_COMPANY
Сompany_name
AIRPLANE_COMPANY
Company name
AIRPORT
Airport code
Airport_name
City
State
FLIGHT
Flight number
Company_name
Weekdays
FLIGHT_LEG
Flight number
Leg number Departure_airport_code Arival_airport_code Scheduled_departure_time Scheduled_arrival_time
Mileage
LEG_INSTANCE
Elight_number
Leg number
Elight date
Departure_airport_code Arrival_airport_code
Number_of_available_seats
Airplane_ID Departure_time Arrival_time
FARE
Flight_number
Fare code
Amount
Restrictions
AIRPLANE
Airplane ID
Max_Seats Airplane type_name
Company_name
CAN LAND
Airplane ID
Airport code
![CUSTOMER
Customer ID
Passport_number
Customer_name
e_mail
Customer phone
Adress
Country
FREQUENT_FLYER_CUSTOMER
Customer ID
Passport_number
Customer_name
e_mail
Customer_phone
Adress
Country
Frequent_flyer_number
TICKET
Ticket number
Flight_number
Leg_number
Flight date
Customer_ID
Fare_amount
Seat_number
Flying_class
CHECK_IN
Ticket number
Customer_ID
Check_configuraiton
TRANSACTION_RECORD
Ticket number
Flight number
Leg number
Customer ID](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Ff2971d27-1e1b-48bb-8864-17c0c6f6f8a2%2F0f517347-d86e-49fd-9d19-93850af8d56f%2Fmjw5qhd_processed.png&w=3840&q=75)
Transcribed Image Text:CUSTOMER
Customer ID
Passport_number
Customer_name
e_mail
Customer phone
Adress
Country
FREQUENT_FLYER_CUSTOMER
Customer ID
Passport_number
Customer_name
e_mail
Customer_phone
Adress
Country
Frequent_flyer_number
TICKET
Ticket number
Flight_number
Leg_number
Flight date
Customer_ID
Fare_amount
Seat_number
Flying_class
CHECK_IN
Ticket number
Customer_ID
Check_configuraiton
TRANSACTION_RECORD
Ticket number
Flight number
Leg number
Customer ID
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
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.Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)
![Principles of Information Systems (MindTap Course…](https://www.bartleby.com/isbn_cover_images/9781285867168/9781285867168_smallCoverImage.gif)
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)
![Principles of Information Systems (MindTap Course…](https://www.bartleby.com/isbn_cover_images/9781285867168/9781285867168_smallCoverImage.gif)
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
![Enhanced Discovering Computers 2017 (Shelly Cashm…](https://www.bartleby.com/isbn_cover_images/9781305657458/9781305657458_smallCoverImage.gif)
Enhanced Discovering Computers 2017 (Shelly Cashm…
Computer Science
ISBN:
9781305657458
Author:
Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:
Cengage Learning