SQL Query matching same values in same column based on criteria

I have a table in MySQL as follows.

I need to find all donors who made at least two constructive in 2022(787, 456). there is also an issue: I can’t use HAVING in the query. How to do this?

>Solution :

There is example how to do this without having in your query, using subqueries

declare
  @year int = '2022'

select
  x.donorId
from (
  select
    count(1) c,
    t.donorId donorId
  from yourtable t
  where t.year = @year
  group by
    t.donorId
) x
where x.c > 1