Number of Favorites by Display Name

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT Upper(OwnerDisplayName) AS Name, SUM(FavoriteCount) AS NumFavs
FROM Posts
WHERE Tags LIKE '%python%'
GROUP BY Upper(OwnerDisplayName)
HAVING SUM(FavoriteCount) > 10
ORDER BY NumFavs DESC

Enter Parameters

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