Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT ROUND(SUM(sellout),2) AS suma, client_002.sales_retailers_mount_updated.sellout_date AS format
- FROM "client_002"."sales_retailers_mount_updated"
- left join "public"."retails" AS "b" ON b.id = sales_retailers_mount_updated.retail_id
- WHERE sales_retailers_mount_updated.retail_id IN (2) AND
- "sales_retailers_mount_updated"."sellout_date" BETWEEN '2017-01-01' AND '2017-01-31'
- GROUP BY 2 ORDER BY 2 ASC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement