프링글이 하는 이야기

select a.* from ( select tmp.*, rank() over (partition by mail_ymd order by (send+blocks) desc) as rank from ( select mail_ymd, org_nm, sum(i_normal_sum+o_normal_sum) send, sum(i_block_sum+o_block_sum) blocks, sum(i_block_control+o_block_control) control, sum(i_block_filter+o_block_filter) filters, sum(i_block_spam+o_block_spam) spam, sum(i_block_user+o_block_user) users, sum(i_block_virus+o_blo..