blob: c1e4a842364ab00c9faea92df855f3e29626ce0b [file] [log] [blame]
SELECT l_orderkey, l_discount, row_number() OVER (PARTITION BY l_orderkey) r1 , sum(l_discount) OVER (PARTITION BY l_orderkey) r2 FROM LINEITEM;