automatically maintained.sql

select
  s.ss_item_sk,
  sum(s.ss_ext_sales_price) as total_sales,
  sum(s.ss_ext_discount_amt) as total_discount
from store_sales s
where s.ss_sold_date_sk = 2452641
group by
  s.ss_item_sk