Q&A for those interested in the geology, meteorology, oceanography, and environmental sciences
select u.DisplayName, 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 , b.date