I have query like below for get sum of purchase and sold traffic. SELECT DATE_FORMAT(order_time,’%d’)AS date, SUM(CASE WHEN seller_id = 1 THEN visitor_quantity ELSE 0 END) AS totalSold, SUM(CASE WHEN buyer_id = 1 THEN visitor_quantity ELSE 0 END) AS totalBought FROM `tbl_orders` WHERE buyer_id = 1 OR seller_id = 1 GROUP BY DATE(order_time) Its working […]