Advertisement
Dodma

Untitled

May 20th, 2020
362
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.29 KB | None | 0 0
  1. SELECT
  2. category,
  3. name,
  4. date_upd :: date,
  5. MAX(price) - MIN(price) AS max_min_diff
  6. FROM
  7. products_data_all
  8. WHERE
  9. category = 'масло сливочное и маргарин' AND date_upd BETWEEN '2019-06-09' AND '2019-06-11'
  10. GROUP BY
  11. category,
  12. name,
  13. date_upd;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement