| select columns[0] as soldd, columns[1] as soldt, columns[2] as itemsk, columns[3] as custsk, columns[4] as cdemo, columns[5] as hdemo, columns[6] as addrsk, columns[7] as storesk, columns[8] as promo, columns[9] as tickn, sum(case columns[10] when '' then 0 else cast(columns[10] as int) end) as quantities from store_sales group by columns[0], columns[1], columns[2], columns[3], columns[4], columns[5], columns[6], columns[7], columns[8], columns[9] order by columns[0], columns[1], columns[2], columns[3], columns[4], columns[5], columns[6], columns[7], columns[8], columns[9]limit 20; |