Advertisement
Guest User

Untitled

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