Major incidents and IT service outages cost companies millions. Often the solution to minimizing damage is automated communication. Find out more in our Major Incident Management Communications infographic.
SELECT CustID, SUM(case when ItemCategory = 10 THEN PubProfit else 0 END) as ChemProfit, AVG(SUM(case when ItemCategory = 10 THEN PubProfit else 0 END)) as ChemAvg, SUM(CASE When InvoiceDate between '2015-1-1' and '2015-12-31' THEN PubProfit ELSE 0 END) as Profit15 From vCustomerInvoiceDetail Where InvoiceDate Between '2015-1-1' and '2015-12-31' Group by CustID Order by Profit15 Desc Limit 150
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.