To calculate the total of all salaries in the accounting department, you should use the SUM group function.
Let's go through each option to understand why it is correct or incorrect:
Option A) MAX - The MAX function is used to find the maximum value in a set of values. It would not provide the total sum of salaries in the accounting department, so this option is incorrect.
Option B) MIN - The MIN function is used to find the minimum value in a set of values. It would not provide the total sum of salaries in the accounting department, so this option is incorrect.
Option C) SUM - The SUM function is used to calculate the total sum of a set of values. This is the correct option because it allows you to add up all the salaries in the accounting department to get the total.
Option D) TOTAL - There is no built-in group function called TOTAL in most database systems. Therefore, this option is incorrect.
The correct answer is C) SUM. This option is correct because the SUM function allows you to calculate the total sum of all salaries in the accounting department.