FIT9132 PASS Week 10

Which of the following returns the total number of rows in a table, including those where all columns are NULL?

• COUNT(column_name)

• COUNT(*)

• SUM(1)

• TOTAL_ROWS()

What does COUNT(DISTINCT column_name) return?

• Total number of rows, including NULLs

• Sum of all values in the column

• Number of distinct non-NULL values in the column

• Number of columns in the table

• Maximum value in the column

Choose the correct execution order of SQL statement clauses:
SELECT ->​ (a)   ->​ (b)   ->​ (c)   ->​ (d)   ->​ (e)  

• FROM
• WHERE
• GROUP BY
• HAVING
• ORDER BY

Which of the following statements about WHERE and HAVING are true?

• WHERE filters rows before grouping.

• HAVING filters groups after aggregation.

• HAVING can reference aggregate functions.

• WHERE can reference aggregate functions.

• HAVING is always evaluated before GROUP BY.

Which clause should you use to filter groups based on an aggregate condition?

• WHERE

• GROUP BY

• HAVING

• FILTER

Which of the following are valid SQL aggregate functions?

• SUM

• MIN

• RANDOM

• AVG

• MAX

Which of these are valid comparison operators for use with subqueries?

• =

• >

• IN

• LIKE

• ANY