1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for Ubuntu users and developers

SELECT 
  Badges.Name AS Badge, 
  COUNT(Badges.Name) AS total 
FROM Badges
  INNER JOIN Users ON Badges.UserId = Users.Id
WHERE 
  Users.Location LIKE '%Algeria%'
    OR 
  Users.Location LIKE '%Algiers%'
GROUP BY
  Badges.Name
ORDER BY
  total DESC

fork query

edited feb 14 13

created feb 11 12 Redouane Zait