MySQL Getting two different total amounts based on criteria

[r937]

@jmyrtle

I believe this is the correct code I need:

what happened when you tested it? ™

please note you may have to disable ONLY_FULL_GROUP_BY

MySQL 5.7.5 and later implements detection of functional dependence. If the ONLY_FULL_GROUP_BY SQL mode is enabled (which it is by default), MySQL rejects queries for which the select list, HAVING condition, or ORDER BY list refer to nonaggregated columns that are neither named in the GROUP BY clause nor are functionally dependent on them. [ my emphasis ] – https://dev.mysql.com/doc/refman/5.7/en/group-by-handling.html

in your query, Customer_Name is functionally dependent on Customer_Number, but Extra_Charge_Amount and Tax_Amount are not functionally dependent on either of the GROUP BY columns

so out of the box you’ll get a grouping syntax error