SELECT source_city, COUNT(destination_city) AS numofdestinations FROM flights f, departures d WHERE f.flight_num = d.flight_num

sanırım böyle teşekkürler