GROUP BY x COMPUTATION

Which of the following statements correctly defines the GROUP BY clause in SQL?

• It is used to group rows that have the same values into summary rows.
• It is used to combine multiple tables into a single table.
• It is used to sort rows in ascending order based on a specific column.
• It is used to filter rows based on a specific condition.

Which SQL function calculates the total sum of a specified column?

• SUM
• COUNT
• MIN
• MAX

Which SQL keyword retrieves the maximum value of a specified column?

• MAX
• MIN
• COUNT
• SUM

What is the average function used for in SQL?

• Calculating the average value of a numerical column
• Finding the maximum value of a column
• Joining two tables together
• Filtering rows based on a condition

Which keyword is used in SQL to calculate the average of a column from a specific table?

• SELECT
• UPDATE
• DELETE
• INSERT