SQL задачи

Решение к #Задача11:

SELECT p.purchase_id,
p.purchase_date,
p.store_id,
pi.product_id,
pi.count * pi.price as total_price
FROM purchase p
JOIN purchase_item pi
ON pi.purchase_id = p.purchase_id
ORDER BY p.store_id, p.purchase_date DESC

#задача

www.tgoop.com/sqlquestions/733

5.27K viewsMay 25, 2022 at 14:44

Решение к #Задача11:

SELECT p.purchase_id,
p.purchase_date,
p.store_id,
pi.product_id,
pi.count * pi.price as total_price
FROM purchase p
JOIN purchase_item pi
ON pi.purchase_id = p.purchase_id
ORDER BY p.store_id, p.purchase_date DESC

#задача

BY SQL задачи