I am trying to get a list of users, who submitted a specific event in a website, however when I run the query, I am not getting the full result set - for example, I found 2 users who had the event (and I used the same conditions), but are not in the result set.
The script looks like:
select userid
, Date
from c
where year(c.Date) = 2018
and week(c.Date) = (week(getdate()) - 1)
and Event in ('existing', 'submit_existing', 'submit_new')
group by 1,2
Can anybody give me a hint what might be the issue?
If anything is unclear or if you have any questions, let me know!
Thanks!