COUNT(*), COUNT(1), COUNT(kolumna) i NULL

WITH sample(value) AS (VALUES (10), (NULL), (10))
SELECT COUNT(*) AS rows,
       COUNT(1) AS ones,
       COUNT(value) AS non_null,
       COUNT(DISTINCT value) AS unique_values
FROM sample;