Question: 4. Write an SQL query to display the flight ID, travel date and the number of tickets booked only for whose travel date is in

4. Write an SQL query to display the flight ID, travel

4. Write an SQL query to display the flight ID, travel date and the number of tickets booked only for whose travel date is in the range from 20/Mar/2021" to "31/Mar/2021" and the number of tickets booked is less than 8. [2 Marks]

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!

Q:

7. Write an SQL query to display the flight id, destination place and the customer name using cross join. Filter the result whose flight id is 201. [2 marks] 8. Write an SQL query to display the...

Q:

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...

Q:

write a SQL query 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...

Q:

write a SQL query 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...

Q:

write a SQL query 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...

Q:

Table Name: DEPT D.id DName 111 Sales Building First Second 112 Accounts 113 First Service HR 114 Second Table Name: EMP Eld Ename Do Depno 113 E101 Ahmed E102 Gaith 111 E103 Hafsa Salary 300.000 625...

Q:

2. Write an SQL Query that will produce a list of Employees first name, and their Department Names. Show the SQL below: 3. Write an SQL Query that will produce a list of Employees first name, and...

Q:

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...

Q:

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...

Q:

Project 3 Details: This project is based on eight tables (AIRPORT, FLIGHT, DEPARTURES, PASSENGER, RESERVATION, EQUIP_TYPE, PILOTS, and TICKET) that contain data about the Belle Airlines. Download and...

Q:

What were some of the key steps that led to Caterpillars becoming the industry leader in earthmoving machinery?

Q:

What do we have in common? During production - If revenue is recognized during production than the prudence concept of accounting is not followed that is to provide for future losses but not for...

Q:

Explain the purpose and contents of a General Ledger master file

Q:

Mozart Piano Studio (MPS) System Mozart Piano Studio (MPS) is a non-profit organization that promotes the performing art of classical piano music. Several advocates came up with the idea offering...