On the same table, COUNT(*) returns 1000 but COUNT(amount) returns 850. What did you just learn?
COUNT(*)
COUNT(amount)