The query on Stack Exchange Data Explorer returns different results from Stack Exchange website

Question

I am running this query on the Stack Exchange Data Explorer (for Stack Overflow):

select owneruserid
 , row_number() over(order by rep desc) as ranking
 , rep
from (
select p.owneruserid
 ,sum(case v.votetypeid when 2 then -- upvote
       case p.posttypeid when 1 then 5 -- Q
                         else 10 end -- A
       else 0 end)
   + sum(case v.votetypeid when 3 then -2 else 0 end) -- downvote
   + sum(case v.votetypeid when 1 then 15 else 0 end) as rep -- accept
from posts p
inner join votes v on v.postid = p.id
inner join users u on u.id = p.owneruserid
where v.creationdate between ##start:string?2018-01-01##
                     and ##end:string?2018-12-31##
and   v.votetypeid in (1,2,3)
and p.owneruserid is not null
group by p.owneruserid
) as rawdata
order by ranking

I aim to get the users ordered by their reputation on year 2018.

The problem is that the Stack Exchange website that corresponds on year 2018 returns quite different results. Top Users of 2018

Am I doing something wrong here or is it an issue on Data Explorer?

Answer 1

It's ... hard ... to calculate reputation with SEDE.

The query does not take into account the reputation cap (200 per day from up/downvotes), nor does it account for bounties (offered/earned).

Slightly less important: the +2 reputation you get from accepting an answer; the -1 from downvoting an answer and the +2 suggested edits to posts (unlikely) and tag wikis (somewhat more likely).