MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE transactions(
   TransactionID INTEGER  NOT NULL
  ,MemberID      INTEGER  NOT NULL
  ,FestYear      INTEGER  NOT NULL
);

INSERT INTO transactions(TransactionID,MemberID,FestYear) VALUES (1,1,2010);
INSERT INTO transactions(TransactionID,MemberID,FestYear) VALUES (2,1,2011);
INSERT INTO transactions(TransactionID,MemberID,FestYear) VALUES (3,1,2012);
INSERT INTO transactions(TransactionID,MemberID,FestYear) VALUES (4,2,2010);
INSERT INTO transactions(TransactionID,MemberID,FestYear) VALUES (5,3,2011);
INSERT INTO transactions(TransactionID,MemberID,FestYear) VALUES (6,3,2012);
INSERT INTO transactions(TransactionID,MemberID,FestYear) VALUES (7,4,2012);
select festYear, sum(rn1 = 1) MemberFirstFestival , sum(rn2 = 1) MemberLastFestival 
from (
    select t.*,
        row_number() over(partition by memberId order by festYear     ) rn1,
        row_number() over(partition by memberId order by festYear desc) rn2
    from transactions t
) t
group by festYear
order by festYear


festYear
MemberFirstFestival
MemberLastFestival


2010
2
1

2011
1
0

2012
1
3