Support Data Maintenance Benchmark about spark-rapids-benchmarks HOT 1 CLOSED

-- DF_CS
-- for catalog_sales 
delete from catalog_sales where cs_sold_date_sk in (select d_date_sk from date_dim where d_date between DATE1 and DATE2);
-- for catalog_returns 
delete from catalog_returns where cr_order_number in (
select cs_order_number from catalog_sales where cs_sold_date_sk in (select d_date_sk from date_dim where d_date between DATE1 and DATE2)
);

-- DF_SS
-- for store_sales 
delete from store_sales 
where ss_sold_date_sk in 
(select d_date_sk from date_dim where d_date between DATE1 and DATE2);
-- for store_sales 
delete from store_returns where sr_ticket_number in (
select ss_ticket_number from store_sales where ss_sold_date_sk in (select d_date_sk from date_dim where d_date between DATE1 and DATE2)
);

-- DF_WS
-- for web_sales 
delete from web_sales where ws_sold_date_sk in (select d_date_sk from date_dim where d_date between DATE1 and DATE2);
-- for web_returns 
delete from web_returns where wr_order_number in (
select ws_order_number from web_sales where ws_sold_date_sk in (select d_date_sk from date_dim where d_date between DATE1 and DATE2)
);

-- DF_I
-- for inventory
delete from inventory where inv_date_sk in (select d_date_sk from date_dim where d_date between DATE1 and DATE2);