12 / 13 SQL Fundamentals

Counting The Paid Ones

Using the orders table above, which has exactly 3 rows with status = 'paid' out of 5 rows total.

Select every expression below that returns 3. More than one is correct.

A

count(NULLIF(status, 'paid'))

B

count(CASE WHEN status = 'paid' THEN 1 ELSE 0 END)

C

sum(CASE WHEN status = 'paid' THEN 1 ELSE 0 END)

D

count(*) FILTER (WHERE status = 'paid')

E

count(CASE WHEN status = 'paid' THEN 1 END)

F

count(status = 'paid')