Roman10

Yeah I'm totally lost on it

Hi guys 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 .. p3-GolfClub-DB.txt