TGViewer
SQL задачи SQL задачи @sqlquestions · 9.98K subscribers
Post #745 5.49K
Решение к #Задача13:

SELECT
pi.product_id,
p.store_id,
pi.price
FROM purchase_item pi
JOIN purchase p
ON p.purchase_id = pi.purchase_id

INTERSECT

SELECT pp.product_id,
pp.store_id,
pp.price
FROM product_price pp

#задача
More from @sqlquestions
  1. Sep 23, 2026Задачка по нашей базе данных, которая находится в шапке канала. Код генерации базы данных…
  2. Sep 9, 2026Шпаргалка. 100 SQL комманд
  3. Aug 18, 2026Post #1551
  4. Aug 18, 2026Post #1549
  5. Aug 10, 2026Post #1548
  6. Aug 3, 2026Post #1547
Threads Profile ViewerView any public Threads profile without an account.Open ThreadLook →Writing with AI? Make it sound human.Metric37 rewrites AI drafts so they read naturally. Free AI detector, 1,500 words free.Try Metric37 →