SELECT DISTINCT VO.SKU , SUM(VO.SHIPPEDQTY) V2.DESCR AS ItemName,
FROM [SCE].vw_ORDERDETAIL_1 vo 
WHERE vo.ACTUALSHIPDATE BETWEEN '2023-01-01 00:00:00' AND '2024-01-01 00:00:00'
AND vo.STORERKEY = 'CLARINS'
AND vo.STATUS = 95
GROUP BY vo.SKU 
HAVING SUM(V1.SHIPPEDQTY) > 0


SELECT TOP 10 * 
FROM [SCE].vw_ORDERDETAIL_1 V1 
INNER JOIN SCE.vw_SKU V2 ON V1.SKU = V2.SKU 
WHERE V1.ACTUALSHIPDATE BETWEEN '2023-01-01 00:00:00' AND '2024-01-01 00:00:00'
AND V1.STORERKEY = 'CLARINS'
AND V1.STATUS = 95