0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for Joomla! administrators, users, developers and designers

Select a.displayname, year (date), count (class) over (partition by a.displayname, year (date)) as Badges_count 
From badges as b inner join users as a on b.userid = a.id
Where a.location = 'South Africa'
And b.name = 'Enlightened' And year(b.Date) = '2016'
Order by Badges_count desc

fork query

created oct 29 20 anonymous