Code Examples

#1 Code Example with MySQL

Code - MySQL

SELECT,,pro.sku, sum(tsl.quantity) as totalSoldQty, LEFT(tsl.created_at, 10) as date
FROM products as pro   
LEFT JOIN transaction_sell_lines tsl on  
where sku=26017 and tsl.created_at between '2019-07-01' and '2019-08-30'
and pro.business_id=7
GROUP BY LEFT(tsl.created_at, 10) 
Copy The Code & Try With Live Editor


Date wise Product Sell Quantity in MySQL