zad2-7

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;