Able to use most common SQL aggregate functions

Question 1

COUNT

Answer 1

COUNT: This function counts the number of rows in a specified column or table.

Question 2

SUM

Answer 2

SUM: This function calculates the sum of values in a specified column.

Question 3

AVG

Answer 3

AVG: This function calculates the average of values in a specified column.

Question 4

MIN

Answer 4

MIN: This function returns the minimum value from a specified column.

Question 5

MAX

Answer 5

MAX: This function returns the maximum value from a specified column.

Question 6

GROUP BY

Answer 6

GROUP BY:

• This clause is used in combination with aggregate functions
• to group rows based on
  
  • one or more columns.

Question 7

HAVING

Answer 7

HAVING: This clause is used

• to filter the results of a GROUP BY query
• based on a condition.