Passenger table (passengerid, address etc.) Flight table (flight id, departure, destination, depDate) Booking table (cID, fid,...

 

Transcribed Image Text:

Passenger table (passengerid, address etc.) Flight table (flight id, departure, destination, depDate) Booking table (cID, fid, date, cost) a. Find Passengers who live in Chicago b. Total number of bookings by month of the flights departing at Chicago c. Which flight earns the most? d. What is the difference between number of flights booked to Chicago in 2022 and number of flights booked to Chicago in 2023? e. Find the names of customers who made more than two bookings before (some date). Q2. Table R with two columns and 5 rows. Contains integers. Table S with two columns and 5 rows. Contains integers. Six different possible result sets are given. a. For R.value= svalue inner join, find which of the result sets is the correct match for this query b. For full outer join, find the correct result set c. For left outer join, find the correct result set d. For right outer join, find the correct result set e. For rid > s.id, find the correct result set for a left outer join. Q4.Employee Table - has two columns - name, manager name a. Find all the managers of 'Jack' b. Find all the common managers of 'Jack' and 'aslan' Passenger table (passengerid, address etc.) Flight table (flight id, departure, destination, depDate) Booking table (cID, fid, date, cost) a. Find Passengers who live in Chicago b. Total number of bookings by month of the flights departing at Chicago c. Which flight earns the most? d. What is the difference between number of flights booked to Chicago in 2022 and number of flights booked to Chicago in 2023? e. Find the names of customers who made more than two bookings before (some date). Q2. Table R with two columns and 5 rows. Contains integers. Table S with two columns and 5 rows. Contains integers. Six different possible result sets are given. a. For R.value= svalue inner join, find which of the result sets is the correct match for this query b. For full outer join, find the correct result set c. For left outer join, find the correct result set d. For right outer join, find the correct result set e. For rid > s.id, find the correct result set for a left outer join. Q4.Employee Table - has two columns - name, manager name a. Find all the managers of 'Jack' b. Find all the common managers of 'Jack' and 'aslan'

Answer rating: 100% (QA)

Lets address each of the questions and queries Q1 Passenger Flight and Booking Tables a To find passengers who live in Chicago sql SELECT FROM Passenger WHERE address LIKE Chicago This query selects a... View the full answer