SELECT Name as label_name, COUNT(Name) as label_cnt FROM ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Different

Q&A for power users of Apple hardware and software

SELECT Name as label_name, COUNT(Name) as label_cnt
FROM Badges
GROUP BY Name 
HAVING COUNT(Name) >= 20 
ORDER BY COUNT(Name) DESC;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results