Practical Data Analysis with SQL/

...

/

Quiz: Grouping and Subtotals

Quiz: Grouping and Subtotals

Test yourself for grouping and subtotals in PostgreSQL.

We'll cover the following...

Test your knowledge about the grouping and subtotals.

1.

(True or False) The expression COUNT(CASE WHEN role = 'Developer' THEN 1 ELSE NULL END) is equivalent to COUNT(*) FILTER (WHERE role = 'Developer').

A.

True

B.

False

1 / 4