ASIN:B09KNNN535
Amazon-Z01813-US


SELECT p_asin, source_id, sum( item_price_amount ),count(DISTINCT amazon_order_id) FROM t_amazon_sales WHERE purchase_date >= '2023-04-04 00:00:00'
AND purchase_date <= '2023-04-18 23:59:59'
and order_status in (1,2,3,4)
AND customer_id = 1
AND asin = 'B09KNNN535'
and source_id=16549
GROUP BY
p_asin,
source_id