Scribd
Upload
3 views2 pages

SQL Server Task Answers-3

The document contains a series of SQL queries targeting various tables such as Passengers, Flights, Bookings, and Payments. Each query is designed to filter and retrieve specific data based on conditions like country, frequent flyer status, ticket prices, and booking status. Additionally, there is a bonus query that joins multiple tables to extract information about confirmed bookings with unpaid payments.

Uploaded by

mahwish965
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
3 views2 pages

SQL Server Task Answers-3

The document contains a series of SQL queries targeting various tables such as Passengers, Flights, Bookings, and Payments. Each query is designed to filter and retrieve specific data based on conditions like country, frequent flyer status, ticket prices, and booking status. Additionally, there is a bonus query that joins multiple tables to extract information about confirmed bookings with unpaid payments.

Uploaded by

mahwish965
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Task 1

SELECT *
FROM Passengers
WHERE Country = 'Pakistan' AND IsFrequentFlyer = 1
ORDER BY FirstName;

Task 2
SELECT *
FROM Flights
WHERE DepartureCity = 'Lahore'
OR (ArrivalCity = 'Dubai' AND TicketPrice < 80000);

Task 3
SELECT *
FROM Passengers
WHERE FirstName LIKE 'A%'
OR LastName LIKE '%Khan'
ORDER BY FirstName;

Task 4
SELECT *
FROM Bookings
WHERE TravelClass = 'Business'
AND BookingStatus = 'Confirmed';

Task 5
SELECT *
FROM Payments
WHERE IsFullyPaid = 0
AND (TotalAmount - PaidAmount) > 50000
AND PaymentMethod = 'Card';

Task 6
SELECT *
FROM Passengers
WHERE DATEDIFF(YEAR, DateOfBirth, GETDATE()) > 60
AND IsFrequentFlyer = 0;
Task 7
SELECT *
FROM Flights
WHERE (Status = 'Delayed' OR Status = 'Cancelled')
AND DepartureDate > '2025-04-01'
ORDER BY DepartureDate;

Task 8
SELECT *
FROM Passengers
WHERE Email IS NULL;

Task 9
SELECT *
FROM Pilots
WHERE IsActive = 0;

Task 10
SELECT *
FROM Passengers
WHERE Country IN ('Pakistan', 'UAE')
AND FirstName LIKE 'M%'
AND IsFrequentFlyer = 1
ORDER BY LastName;

Bonus Query
SELECT [Link], [Link], [Link], [Link]
FROM Passengers P
JOIN Bookings B ON [Link] = [Link]
JOIN Flights F ON [Link] = [Link]
JOIN Payments PM ON [Link] = [Link]
WHERE [Link] = 'Confirmed'
AND [Link] = 0
ORDER BY [Link];

You might also like