How to Aggregate Data

Create dclk_summ as

Select oneg_id,

       Sum(clicks_cnt) as clk,

       Sum(cost_amt)   as cost,

       Sum(hotel_margin+air_margin) as ha_margin,

       Sum(cost_amt)/sum(tot_margin) as SR

From dclk_data

Group by oneg_id