SQL - Query to display average as either "longer than" or "shorter than"
- by user1840801
Here are the tables I've created:
CREATE TABLE Plane_new (Pnum char(3), Feature varchar2(20), Ptype varchar2(15),
primary key (Pnum));
CREATE TABLE Employee_new (eid char(3), ename varchar(10), salary number(7,2), mid char(3),
PRIMARY KEY (eid), FOREIGN KEY (mid) REFERENCES Employee_new);
CREATE TABLE Pilot_new (eid char(3), Licence char(9),…