Preview:
SELECT DISTINCT  V1.SKU AS SKU, V2.DESCR AS ItemName, SUM(V1.SHIPPEDQTY) 
FROM SCE.vw_ORDERDETAIL_1 V1
INNER JOIN SCE.vw_SKU V2 ON V1.SKU = V2.SKU 
WHERE V1.ACTUALSHIPDATE BETWEEN '2024-01-01 00:00:00' AND GETDATE()
GROUP BY v1.SKU, V2.DESCR
HAVING SUM(V1.SHIPPEDQTY) > 0
downloadDownload PNG downloadDownload JPEG downloadDownload SVG

Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!

Click to optimize width for Twitter