Q&A about the site for builders and users of networked sensors and control devices in the contexts of smart homes, industry automation, or environmental sensors
---Popular badges. Pets Exchange has an elaborate badging system.
---Use the badges table to find the most common type of badges.
---Specifically, show badge name (label name) and the number of people who won it (label cnt),
---limiting results to badges with at least 20 winners and sort the results by cnt in a descending order.
SELECT Name, COUNT(*) as cnt
GROUP BY Name
HAVING COUNT(*) > 20