Greetings! Upvotes apply to top level posts and also comments - both are counted.
My own code counts every vote that is above zero, but there are some anomalies in the data surrounding posts that are close to zero, but they are so close to zero that they are irrelevant really.
There are some entries in SteemSQL which have missing data currently and @arcange is aware of this and looking at finding a fix for it. The result is that some votes are not being counted. There's nothing I can personally do about this, so I am waiting on Arcange's fix.

I have replied to @afolwalex below.