Confusing alias mySQL
- by Taylor
I keep getting the same number outputted for the Total Sales, Minimum Sale, Largest Sale and Average Sale.
The Total Invoices is working perfectly, but I cant seem to figure out how to fix the other ones.
Here's the query:
SELECT SUM( b.`Number of Invoices`) AS `Total Invoices`,
SUM( b.`Total Customer Purchases`) AS `Total Sales`,
…