In an SQL query,the built-in functions SUM and AVG work with columns containing data of which of the following data types?
A)Integer
B)Numeric
C)Char
D)Both A and B are correct

Question

Quizplus · Accepted Answer

The SUM and AVG functions are used to calculate the sum and average of a set of values. They work with columns that contain numeric data, such as integers or decimals, which are represented in SQL as data types INTEGER and NUMERIC. They do not work with columns that contain character data, such as CHAR. Therefore, the correct choices are A) Integer and B) Numeric, which are both included in option D).

In an SQL Query,the Built-In Functions SUM and AVG Work