The answer could be B or C.
the twist is in the COUNT function, if count function is applied on whole table, COUNT(*), then the answer will be C.
and if the COUNT function is applied on rating attribute, COUNT(rating), then the result will be equal to that of AVERAGE function B.