I have 3 tables which are (flight, model, airplane)
Flight: fid, pid, aid, plannedDeparture, actualDeparture, passengerCount, destination
Model: mid, name, usefulLoad, pilotCount
Airplane: aid, mid, oid, hid, dateAqu
and I need to generate a report (query) for overloaded flights. Assuming the following:
- the passenger/pilot weight is 160 lb on average;
- fuel takes 65% of the useful load.
Including in the report the following data: flightID (fid), destination, plannedDeparture, passengerCount, airplaneID (aid), airplaneModel (Model.name), usefulLoad, totalLoad (calculated), overLoad (calculated), passengerSurplus (calculated).
and I'm really sticking on it, I'm not an advanced user on mysql so I would really appreciate helping me here.
** I attached my schema ..