Q&A for users and developers of the Cardano cryptocurrency ecosystem
select u.DisplayName, year(b.date),count(b.id) from users u join badges b on u.id = b.userid where u.DisplayName = 'Adriaan Stander' group by u.DisplayName ,year(b.date)