12311k

Untitled

Feb 27th, 2020
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.30 KB | None | 0 0
  1. SELECT
  2. AVG(price) AS avg_price
  3. FROM
  4. products_stores
  5. WHERE
  6. date_upd ='2019-06-01' AND id_product IN
  7. (SELECT
  8. id_product
  9. FROM
  10. products
  11. WHERE
  12. name LIKE '%Му%' AND category ='молоко и сливки');
Add Comment
Please, Sign In to add comment