That Awkward Moment...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Ubuntu

Q&A for Ubuntu users and developers

SELECT 
  *
FROM 
  Users u
INNER JOIN
  (SELECT b.UserId, COUNT(*) n FROM Badges b WHERE b.Name = 'Tumbleweed' GROUP BY b.UserId) a
ON
  a.UserId = u.Id
ORDER BY
  a.n DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results