Hi guys
I have 4 tables which are (flight, model, airplane, pilot)
Flight: fid, pid, aid, plannedDeparture, actualDeparture, passengerCount, destination
Model: mid, name, usefulLoad, pilotCount
Airplane: aid, mid, oid, hid, dateAqu
Pilot: pid, hireDate
and I need to generate a report (query) for overloaded flights. Assuming the following:
- the passenger/pilot weight is 160 lb on average;