Question 1

0

Please login or register to vote for this query.

(click on this box to dismiss)

Internet of Things Meta

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
FROM Badges
GROUP BY Name

Enter Parameters

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