Flyvninger SQL Spørringer

# 1.1
SELECT * FROM Flyplass;

# 1.2
SELECT Rullebane.RKode, Rullebane.RPos, Rullebane.RLengde FROM Rullebane WHERE Rullebane.Flyplass_FpKode = "OSL";

# 1.3
SELECT
    Dato,
    Klokkeslett,
    Reisetype,
    Fly.FlKode,
    Fly.FlPP AS `Flyseter`,
    Fly.FlAntP AS `Passasjerer`,
    Fly.FlSelskap,
    Rullebane.RKode,
    Rullebane.RLengde,
    Rullebane.RPos,
    Flyplass.FpTlf,
    Flyplass.FpNavn,
    Flyplass.FpKode
FROM
    Reise,
    Fly,
    Rullebane,
    Flyplass
WHERE Reise.Dato = "15.05.15"
    AND Reise.Fly_FlKode = Fly.FlKode
    AND Fly.Rullebane_RKode = Rullebane.RKode
    AND Rullebane.Flyplass_FpKode = Flyplass.FpKode
ORDER BY Reise.Klokkeslett ASC;