Aggregations

Which of the following statements are valid?

• Where clause and having clause will impact the result of group by in the same way

• we can use multiple functions in one query using group by clause

• This is how we should right query using group by in postgres:

  select ...

  from ...

  group by ...

  where ...

  having ...

  order by ...

• FILTER is a modifier used on an aggregate function to limit the values used in an aggregation

Which ones of the following options are Aggregate functions?

• COUNT

• SUM

• AVG

• LOWER

Which clause/clauses can be used with aggregate functions?

• DELETE

• SELECT

• HAVING

• UPDATE

Which of the following is not a valid aggregate function?

• COUNT

• COMPUTE

• SUM

• MAX

What is the right aggregate function to calculate the total value of an attribute?

• Count

• SUM

• AVG

• None

Does the Count function work on the non-numeric data types?

• Yes, it does!

• No, it doesn't!

Which of the following pairs can be used instead of AVG?

• SUM, MIN

• COUNT, MAX

• SUM, COUNT

• SUM, MAX

Which one of there aggregate functions doesn't support DISTINCT?

• COUNT

• SUM

• AVG

• MIN

what can we use if we want the SUM() function to return zero instead of NULL in case there is no matching row found?

• MIN

• COALESCE

• MAX

• COUNT