Gina is working with a query that includes an Income field and a Month field. She wants the query to return the total income for each month. She can sort the query by the values in the Month column and then create a column that sums the Income field.

Question

Quizplus · Accepted Answer

Sorting the query by the Month column does not automatically sum the Income field. Gina needs to use a GROUP BY clause on the Month field and apply a SUM function to the Income field to achieve the desired result.

Gina Is Working with a Query That Includes an Income