Q66
SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN.
A.
True
AnswerB.
False
Answer: Option A
Solution
Answer: Option A
Solution:
SQL does indeed provide five built-in functions for aggregate operations:COUNT: Counts the number of rows or non-null values in a column.
SUM: Calculates the sum of numeric values in a column.
AVG: Computes the average of numeric values in a column.
MAX: Retrieves the maximum value from a column.
MIN: Retrieves the minimum value from a column.
These functions are fundamental for data analysis and reporting tasks within SQL queries.
Conclusion:
The statement "SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN" is Option A: True. Hence, the correct answer is True.