SELECT airplane.airplane_code, airplane.model, count(flight.airplane_code)
FROM airplane, flight
WHERE airplane.airplane_code = flight.aiplane_code
WHERE airplane.airplane_code = flight.airplane_code -- najdi 7 rozdilu :)
HAVING count(flight.airplane_code)>1;