Задача 38

From Martin Movsisyan, 2 Months ago, written in SQL, viewed 69 times. This paste is a reply to Задача 38 from Martin Movsisyan - view diff

URL http://codebin.org/view/bad7c890 Embed

Download Paste or View Raw

WITH a AS -- товары после 2012
(SELECT p.name, pv.vendor_id, p.product_id, pv.last_receipt_date
FROM adventure.product_vendor AS pv
LEFT JOIN adventure.product AS p ON pv.product_id=p.product_id
WHERE pv.last_receipt_date >= '2012-01-01'
ORDER BY product_id),
b AS -- сумма заказа за все время
(SELECT product_id, SUM(unit_price*order_qty) AS total
FROM adventure.purchase_order_detail
GROUP BY product_id)
 
SELECT name, total
FROM a
JOIN b ON a.product_id=b.product_id
ORDER BY 2,1

Replies to Задача 38

Title	Name	Language	When
Задача 38	Martin Movsisyan	sql	2 Months ago.

Reply to "Задача 38"

Here you can reply to the paste above

Author What's your name?

Title Give your paste a title.

Language What language is your paste written in?

Your paste Paste your paste here

Create Shorturl Create a shorter url that redirects to your paste?

Private Private paste aren't shown in recent listings.

Delete After When should we delete your paste?