SELECT ACTIVITY_DAY AS "Date"
    ,MARKETPLACE_ID AS "Market"
    ,TRAFFIC_CHANNEL_ROLLUP AS "Traffic_Channel"
    ,(SUM(OPS) - SUM(FIRST_HIT_OPS)) AS "FirstHit_NonDeals_OPS"
    ,
FROM CSE_REPO_DDL.PAGE_METRICS
WHERE DATA_LEVEL = 6
    AND MARKETPLACE_ID IN (
        3
        ,4
        ,5
        ,35691
        ,44551
        )
    AND ACTIVITY_DAY BETWEEN TO_DATE('2016/01/01', 'yyyy/mm/dd')
        AND TO_DATE('2016/01/02', 'yyyy/mm/dd')
    AND ROWNUM <= 10
GROUP BY ACTIVITY_DAY
    ,MARKETPLACE_ID
    ,TRAFFIC_CHANNEL_ROLLUP
ORDER BY ACTIVITY_DAY ASC;