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
Preview:
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