AVG(PAY) will evaluate to 250. AVG() function ignores NULL values, so it will calculate average over all records containing not NULL values.
SUM(PAY) will evaluate to 1000 for the same reason.
COUNT(*) will evaluate to 5 as there are 5 records in the table. It doesn't make any distinctions for NULL values whatsoever.
So, the query will return 250 -1000/5=50.
Войдите чтобы поставить Нравится
Войдите чтобы прокомментировать