SELECT COUNT(USERS.ID), location from users where UPPER(u...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stellar Meta

Q&A about the site for developers and users of Stellar and the Stellar Distributed Exchange

SELECT COUNT(USERS.ID), location
from users
where UPPER(users.displayname) like 'ANDR%'
GROUP BY LOCATION
HAVING COUNT(ID) > 100
ORDER BY COUNT(USERS.ID) DESC

Enter Parameters

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