深圳智汇创想科技有限公司

SELECT purchase_date,msku,sum(sale_amount) FROM t_amz_product_performance   where source_id=6605 and purchase_date>='20230607' and msku='2157458-6605-1014076531' GROUP BY msku,purchase_date ORDER BY purchase_date;

SELECT purchase_date_day,msku,sum(item_price_amount) FROM t_amazon_sales where  purchase_date_day>='20230607' and source_id =6605
and msku ='2157458-6605-1014076531'
and order_status in (1,2,3,4)
and multi_channel_flag=0

GROUP BY msku ,purchase_date_day ORDER BY purchase_date_day;

少了7号的数据

14，15号的数据对不上