select distinct source_city, count(*) from(
select distinct source_city, destination_city from flights
)
group by source_city