SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE Airlines (aid integer PRIMARY KEY,name text); CREATE TABLE Airports (apid integer PRIMARY KEY,name text); CREATE TABLE Flights (fid integer PRIMARY KEY, airline integer, start_airport integer, end_airport integer, duration integer); ALTER TABLE Flights ADD FOREIGN KEY (airline) REFERENCES Airlines(aid); ALTER TABLE Flights ADD FOREIGN KEY (start_airport) REFERENCES Airports(apid); ALTER TABLE Flights ADD FOREIGN KEY (end_airport) REFERENCES Airports(apid); With (Select F.start_airport, count(*) as c From Flights F Group by F.start_airport) As T, Select AP.name FROM T, Airports AP Where T.c >= (select max(T.c) from T) And AP.apid = T.start_airport
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear