Analytical function window

gistfile1.txt

with cf as (select
		unique_carrier,
	 	origin_city, 
		origin_state, 
		destination_city_name,
		destination_state,
		sum (case when arrival_delay > 0 then 1 else 0 end) as count_delayed_flights,
		count(arrival_delay) as total_flight_count
	    from "ArrivalInfo" 
	    group by 
		unique_carrier,
		origin_city,
		origin_state,
		destination_city_name,
		destination_state),
    df as (select
    		unique_carrier,
    		origin_city, 
		origin_state, 
		destination_city_name,
		destination_state,
		count_delayed_flights,
		sum (count_delayed_flights) 
			over (partition by origin_city, origin_state, destination_city_name, destination_state) as delayed_per_origin,
		total_flight_count
           from cf)	  		   
select * from df;