Advertisement
Alaricy

Расш. возм. SQL. Групперуем данные. задача 4/4

Jan 14th, 2022
149
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.20 KB | None | 0 0
  1. SELECT
  2.     name,
  3.     MAX(price)-MIN(price) AS max_min_diff
  4. FROM
  5.     products_data_all
  6. WHERE
  7.     category = 'масло сливочное и маргарин' AND
  8.     date_upd = '2019-06-10'
  9. GROUP BY
  10.     name
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement