Hello, I would like to assist you on this.
Could you May i know on what basis do you want number of flights?
let me reply you shortly sir.sorry for it.
select city.name as cityname, count(flight.number) as NoOfFlights , flight.number as flightnumber from city left join flight on flight.origincityid = city.id group by flight.origincityid, flight.number, city.name
great to hear that. Please accept the answer if it helps. Please let me know if you have any issue. I will make sure to complete it ASAP. I had connectivity problems since last two days so really sorry to reply you so late. Have a good day ahead.