I have a table with States MN and WI and each state lists how many Red apples and how many Green apples. The SQL below shows, for example, MN has 3 green and 4 red, and state WI has 3 green and 6 red. How can I see the total number of apples? 3 + 4 + 3 + 6 = 16 Can I show the total 16 in my query or do I need to use a Report? I could not figure out how to do this in either a Query or a Report. Thanks for your help.
SELECT apples.State, apples.AppleColor, Count(apples.AppleColor) AS CountOfAppleColor
FROM apples
GROUP BY apples.State, apples.AppleColor;