Which of the following is the correct syntax to count only rows where status = 'active' using FILTER in PostgreSQL?

easy📝 Syntax Q12 of 15

PostgreSQL - Aggregate Functions and GROUP BY

Which of the following is the correct syntax to count only rows where status = 'active' using FILTER in PostgreSQL?

ASELECT COUNT(*) FILTER (WHERE status = 'active') FROM users;

BSELECT COUNT(*) FROM users FILTER (WHERE status = 'active');

CSELECT COUNT(*) WHERE FILTER status = 'active' FROM users;

DSELECT COUNT(*) FILTER WHERE status = 'active' FROM users;

Step-by-Step Solution

Solution:

Step 1: Recall FILTER syntax in aggregate functions
The correct syntax places FILTER with parentheses and a WHERE clause inside the aggregate function: COUNT(*) FILTER (WHERE condition).
Step 2: Check each option
SELECT COUNT(*) FILTER (WHERE status = 'active') FROM users; matches the correct syntax. The other options misuse FILTER placement or syntax.
Final Answer:
SELECT COUNT(*) FILTER (WHERE status = 'active') FROM users; -> Option A
Quick Check:
FILTER syntax = FILTER (WHERE condition) [OK]

Quick Trick: Use FILTER (WHERE condition) inside aggregate parentheses [OK]

Common Mistakes:

Master "Aggregate Functions and GROUP BY" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free