q1.sql

SELECT 
	PartNum, 
	CONVERT(DECIMAL(16, 4), (SUM(OurShipQty) * .5)) AS QuarterTotal, 
	CONVERT(DECIMAL(16, 4), (SUM(OurShipQty) / 3) * .5) AS MonthAvg,
	CONVERT(DECIMAL(16, 4), (((STDEV(OurShipQty)) * .5) * (COUNT(PartNum) * .5))) AS MonthStd,
	CONVERT(DECIMAL(16, 4), (AVG(OurShipQty)) * .5) AS PartAvg,
	CONVERT(DECIMAL(16, 4), (STDEV(OurShipQty)) * .5) AS PartStd,
	CONVERT(DECIMAL(16, 4), (COUNT(PartNum)) * .5) AS Hits,
	COUNT(DISTINCT CustID) AS Customers,
	Plant
FROM 
	dbo.v_InvoiceRegister
WHERE
	(InvoiceDate > DATEADD(month, - 12, GETDATE())) AND 
	(InvoiceDate <= DATEADD(month, - 9, GETDATE())) AND 
	(TermsCode NOT IN ('16', '26', '14', 'PORD', '50%D', '50%S')) AND 
	(NetExtPrice > 0) AND
	(BuyToOrder <> 'TRUE')
GROUP BY 
	PartNum,
	Plant