SELECT ACTIVITY_DAY
    ,MARKETPLACE_ID
    ,TRAFFIC_CHANNEL_ROLLUP
    ,SUM(Units)
    ,SUM(OPS)
    ,SUM(SESSIONS)
    ,SUM(NEW_TO_SITE_CUST)
    ,SUM(NEW_TO_GL_CUST)
    ,SUM(FIRST_HIT_SESSIONS)
    ,SUM(FIRST_HIT_UNITS)
    ,SUM(FIRST_HIT_OPS)
    ,SUM(FIRST_HIT_NEW_TO_SITE_CUST)
    ,SUM(FIRST_HIT_NEW_TO_GL_CUST)
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;