Advertisement
Guest User

Untitled

a guest
Jun 27th, 2017
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.41 KB | None | 0 0
  1. SELECT  ROUND(SUM(sellout),2) AS suma, client_002.sales_retailers_mount_updated.sellout_date AS format
  2. FROM "client_002"."sales_retailers_mount_updated"
  3. left join "public"."retails" AS "b" ON b.id = sales_retailers_mount_updated.retail_id
  4. WHERE sales_retailers_mount_updated.retail_id IN (2) AND
  5. "sales_retailers_mount_updated"."sellout_date" BETWEEN '2017-01-01' AND '2017-01-31'
  6. GROUP BY 2 ORDER BY 2 ASC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement