check.sql

select sysdate TODAY,sysdate-1 YESTERDAY

 from dual;

 

select to_char('                                         ')  divide 

from dual;

 

select run_date YESTERDAY,sum(sale_amount) CS_AMOUNT

 from tb_fin_art_stock_jxc@store51
where run_date in (select max(run_date) from tb_fin_art_stock_jxc@store51)
and art_grp_no<400

group by run_date;

 

select run_date YESTERDAY,sum(sale_amount) BH_AMOUNT

 from tb_fin_art_stock_jxc@store51
where run_date in (select max(run_date) from tb_fin_art_stock_jxc@store51)
and art_grp_no>400

group by run_date;

 

select sum(visit_numb) CS_visit

 from st_time_visit@headof 
where  visit_itv not in (500,444)
and visit_date in (select max(run_date) from tb_fin_art_stock_jxc@store51);

 

select sum(visit_numb) BH_visit

 from st_time_visit@headof 
where  visit_itv in (500,444) and visit_date in (select max(run_date)
from tb_fin_art_stock_jxc@store51);