Skip to content

Instantly share code, notes, and snippets.

@jonedmiston

jonedmiston/Q&A Points

Created June 16, 2017 05:51
Show Gist options
  • Save jonedmiston/59f2c6ffee95279a8f09aa2d8036cec4 to your computer and use it in GitHub Desktop.
Save jonedmiston/59f2c6ffee95279a8f09aa2d8036cec4 to your computer and use it in GitHub Desktop.
Download ZIP
Q&A Points
Raw
Q&A Points
SELECT TOP (1000)
[PersonId]
,[Points]
,[VotePoints]
, [NickName]
, [Lastname]
FROM [RockRMS-Spark].[dbo].[_org_sparkDevNetwork_QandA_Author] a
INNER JOIN [Person] p ON p.[Id] = a.[PersonId]
WHERE [Points] < 10000
ORDER BY [Points] DESC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment