It's easy! Check out this step-by-step guide for asking an anonymous question on Experts Exchange.
SELECT storeinfo.description AS [Store Name], SUM(posheader.nettotal) AS [Net Total], COUNT(transact) AS [Transaction Count], [Net Total] / [Transaction Count] AS [Transaction Average], SUM(totalwage) AS [Labor] FROM posheader INNER JOIN storeinfo on posheader.snum = storeinfo.storenum INNER JOIN punchpayroll on posheader.snum = punchpayroll.snum WHERE posheader.status = 3 AND posheader.opendate = 20160802 AND punchpayroll.opendate = 20160802 GROUP BY [Store Name] ORDER BY [Store Name]
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.