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