Tag: mysql

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 […]