0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for software developers, mathematicians and others interested in cryptography

SELECT 
    ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#],
    Id AS [User Link],
    Reputation,
    LastAccessDate,
    Location
FROM
    Users
WHERE
    LOWER(Location) LIKE '%trinidad and tobago%'
ORDER BY
    Reputation DESC, LastAccessDate DESC;
    
    
    
SELECT TOP 200
P.owneruserid [User Link],
COUNT(1) [BOUNTY ANSWERS PROVIDED],
(SELECT LOCATION FROM USERS U WHERE U.ID = P.OWNERUSERID) AS [COUNTRY]
FROM POSTS P,VOTES 
WHERE P.ID = POSTID
AND VOTETYPEID = 9
GROUP BY OWNERUSERID
--HAVING  COUNT(1) > 45
ORDER BY 2 DESC

fork query

created dec 13 anonymous