Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT *
- FROM Flights
- WHERE DepartureAirport = 'SOF'
- AND Duration < '05:00:00';
- SELECT DepartureAirport, AVG(Duration) AS AverageDuration
- FROM Flights
- GROUP BY DepartureAirport;
- SELECT Flights.FlightID, Flights.DepartureDateTime, Aircraft.AircraftName
- FROM Flights
- INNER JOIN Aircraft ON Flights.AircraftID = Aircraft.AircraftID;
- SELECT Flights.FlightID, Flights.DepartureDateTime, Crew.CrewName
- FROM Flights
- LEFT OUTER JOIN Crew ON Flights.CrewID = Crew.CrewID;
- SELECT *
- FROM Flights
- WHERE FlightID IN (
- SELECT FlightID
- FROM FlightSchedule
- WHERE CrewID = 1
- );
- SELECT Flights.DepartureAirport, SUM(Aircraft.Capacity) AS TotalCapacity
- FROM Flights
- JOIN Aircraft ON Flights.AircraftID = Aircraft.AircraftID
- WHERE Flights.DepartureAirport = 'SOF'
- GROUP BY Flights.DepartureAirport;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement