Why SUM() and COUNT() Return Different Values?

Counting Similar Events in the Previous 7 Days with Pandas

How to Select Latest Submission for Each Subject Using SQL GROUP BY as Inner Query