Advertisement
pozdnyakov

У кого слишком большие цифры

Mar 30th, 2018
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT DISTINCT  e.title, e.id, good, "EAN", "prevSum", "currSum",  "prevQuantity" AS "Предыдущие закупки", "currQuantity" as "Закуплено" /*r.title, r.manufacturer*/ FROM "CampaignProgress"
  2.   JOIN "Endpoints" E ON "CampaignProgress".endpoint = E.id
  3.  -- JOIN "ResellerGood" r ON r.id = "CampaignProgress".good
  4. WHERE date BETWEEN '2017.01.01' AND '2018.03.30' -- Период акций
  5. AND  "CampaignProgress"."currSum">1000 -- Текущ. закупки
  6.     AND "currQuantity">10 -- сколько было закуплено
  7.  AND  "CampaignProgress"."prevSum" / "CampaignProgress"."currSum" <0.1
  8. --WHERE e.title LIKE '%(с.Красноборск,ул.Гагарина,д.41)%'
  9. ORDER BY "currSum" DESC ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement