Question: Table Structure: flight COLUMN NAME DATA TYPE SIZE Constraint Fid Number 3 Primary key Fname Varchar 2 10 Splace Varchar 2 8 Dplace Varchar 2

 Table Structure: flight COLUMN NAME DATA TYPE SIZE Constraint Fid Number

3 Primary key Fname Varchar 2 10 Splace Varchar 2 8 Dplace

Table Structure: flight COLUMN NAME DATA TYPE SIZE Constraint Fid Number 3 Primary key Fname Varchar 2 10 Splace Varchar 2 8 Dplace Varchar 2 8 Tdate date Seats Number 3 Note: Fid is Fight ID, Fname is Flight Name, Splace is a source place where the flight starts Dplace is destination place where the flight will reach, Tdate is tremel date of the flight and seats are the number of seats awilable in the flight Records inserted in to the flight table Fid Fname Splace Dplace Tdate Seats 101 Oman Air Muscat Delhi 20-Jan-2021 78 102 Air India Muscat Chennai 31-Dec-2020 null 201 Indigo Dubai Muscat 12-Feb-2021 93 103 Oman Air Chennai Dubai 23-Dec-2020 82 205 Air India Delhi Muscat 14-Feb-2021 115 202 Indigo Chennai Delhi 23-Jan-2021 null 1. Write an SQL query to display the following output using proper built in functions. Seats Date of Travel 2020. Dec - 23 20 20 2021, Feb - 14 2021, Jan - 20 20 20 2021, Feb - 12 2021, Jan - 23 40 40 2020, Dec - 31

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!