Two Ways To Count

Table readings:

id sensor value
1 a 10
2 a NULL
3 a 20
4 b NULL
SELECT sensor,
       count(*)     AS c_star,
       count(value) AS c_val,
       sum(value)   AS total,
       avg(value)   AS mean
FROM readings
GROUP BY sensor
ORDER BY sensor;

What are the two output rows?

A

a, 2, 2, 30, 15 and b, 0, 0, NULL, NULL

B

a, 3, 2, 30, 15 and b, 1, 0, NULL, NULL

C

a, 3, 2, 30, 10 and b, 1, 0, NULL, NULL

D

a, 3, 2, 30, 15 and b, 1, 0, 0, 0