Editing Query

(1) The top 200 users on a given Stack Exchange community; (2) How many days they've hit the reputation cap (200 points) (3) How many days they've been a member; (4) Average number of rep caps per 365 days (Forked from http://meta.stackexchange.com/questions/234720/custom-query-data-explorer-rep)

edit description
Stack Overflow

Q&A for professional and enthusiast programmers

Database Schema
  • Posts
    Id
    int
    PostTypeId
    tinyint
    AcceptedAnswerId
    int
    ParentId
    int
    CreationDate
    datetime
    DeletionDate
    datetime
    Score
    int
    ViewCount
    int
    Body
    nvarchar (max)
    OwnerUserId
    int
    OwnerDisplayName
    nvarchar (40)
    LastEditorUserId
    int
    LastEditorDisplayName
    nvarchar (40)
    LastEditDate
    datetime
    LastActivityDate
    datetime
    Title
    nvarchar (250)
    Tags
    nvarchar (4000)
    AnswerCount
    int
    CommentCount
    int
    FavoriteCount
    int
    ClosedDate
    datetime
    CommunityOwnedDate
    datetime
    ContentLicense
    varchar (30)
  • Users
    Id
    int
    Reputation
    int
    CreationDate
    datetime
    DisplayName
    nvarchar (40)
    LastAccessDate
    datetime
    WebsiteUrl
    nvarchar (200)
    Location
    nvarchar (100)
    AboutMe
    nvarchar (max)
    Views
    int
    UpVotes
    int
    DownVotes
    int
    ProfileImageUrl
    nvarchar (200)
    EmailHash
    varchar (32)
    AccountId
    int
  • Comments
    Id
    int
    PostId
    int
    Score
    int
    Text
    nvarchar (600)
    CreationDate
    datetime
    UserDisplayName
    nvarchar (40)
    UserId
    int
    ContentLicense
    varchar (30)
  • Badges
    Id
    int
    UserId
    int
    Name
    nvarchar (50)
    Date
    datetime
    Class
    tinyint
    TagBased
    bit
  • CloseAsOffTopicReasonTypes
    Id
    smallint
    IsUniversal
    bit
    InputTitle
    nvarchar (100)
    MarkdownInputGuidance
    nvarchar (500)
    MarkdownPostOwnerGuidance
    nvarchar (500)
    MarkdownPublicGuidance
    nvarchar (500)
    MarkdownConcensusDescription
    nvarchar (500)
    CreationDate
    datetime
    CreationModeratorId
    int
    ApprovalDate
    datetime
    ApprovalModeratorId
    int
    DeactivationDate
    datetime
    DeactivationModeratorId
    int
  • CloseReasonTypes
    Id
    tinyint
    Name
    nvarchar (200)
    Description
    nvarchar (500)
  • FlagTypes
    Id
    tinyint
    Name
    nvarchar (50)
    Description
    nvarchar (500)
  • PendingFlags
    Id
    int
    FlagTypeId
    tinyint
    PostId
    int
    CreationDate
    date
    CloseReasonTypeId
    tinyint
    CloseAsOffTopicReasonTypeId
    smallint
    DuplicateOfQuestionId
    int
    BelongsOnBaseHostAddress
    nvarchar (100)
  • PostFeedback
    Id
    int
    PostId
    int
    IsAnonymous
    bit
    VoteTypeId
    tinyint
    CreationDate
    datetime
  • PostHistory
    Id
    int
    PostHistoryTypeId
    tinyint
    PostId
    int
    RevisionGUID
    uniqueidentifier
    CreationDate
    datetime
    UserId
    int
    UserDisplayName
    nvarchar (40)
    Comment
    nvarchar (400)
    Text
    nvarchar (max)
    ContentLicense
    varchar (30)
  • PostHistoryTypes
    Id
    tinyint
    Name
    nvarchar (50)
  • PostLinks
    Id
    int
    CreationDate
    datetime
    PostId
    int
    RelatedPostId
    int
    LinkTypeId
    tinyint
  • PostNotices
    Id
    int
    PostId
    int
    PostNoticeTypeId
    int
    CreationDate
    datetime
    DeletionDate
    datetime
    ExpiryDate
    datetime
    Body
    nvarchar (max)
    OwnerUserId
    int
    DeletionUserId
    int
  • PostNoticeTypes
    Id
    int
    ClassId
    tinyint
    Name
    nvarchar (80)
    Body
    nvarchar (max)
    IsHidden
    bit
    Predefined
    bit
    PostNoticeDurationId
    int
  • PostsWithDeleted
    Id
    int
    PostTypeId
    tinyint
    AcceptedAnswerId
    int
    ParentId
    int
    CreationDate
    datetime
    DeletionDate
    datetime
    Score
    int
    ViewCount
    int
    Body
    nvarchar (max)
    OwnerUserId
    int
    OwnerDisplayName
    nvarchar (40)
    LastEditorUserId
    int
    LastEditorDisplayName
    nvarchar (40)
    LastEditDate
    datetime
    LastActivityDate
    datetime
    Title
    nvarchar (250)
    Tags
    nvarchar (4000)
    AnswerCount
    int
    CommentCount
    int
    FavoriteCount
    int
    ClosedDate
    datetime
    CommunityOwnedDate
    datetime
    ContentLicense
    varchar (30)
  • PostTags
    PostId
    int
    TagId
    int
  • PostTypes
    Id
    tinyint
    Name
    nvarchar (50)
  • RelatedQuestions
    PostId
    int
    RelatedPostId
    int
    Position
    int
    Score
    decimal
  • ReviewRejectionReasons
    Id
    tinyint
    Name
    nvarchar (100)
    Description
    nvarchar (300)
    PostTypeId
    tinyint
  • ReviewTaskResults
    Id
    int
    ReviewTaskId
    int
    ReviewTaskResultTypeId
    tinyint
    CreationDate
    date
    RejectionReasonId
    tinyint
    Comment
    nvarchar (400)
  • ReviewTaskResultTypes
    Id
    tinyint
    Name
    nvarchar (100)
    Description
    nvarchar (300)
  • ReviewTasks
    Id
    int
    ReviewTaskTypeId
    tinyint
    CreationDate
    date
    DeletionDate
    date
    ReviewTaskStateId
    tinyint
    PostId
    int
    SuggestedEditId
    int
    CompletedByReviewTaskId
    int
  • ReviewTaskStates
    Id
    tinyint
    Name
    nvarchar (50)
    Description
    nvarchar (300)
  • ReviewTaskTypes
    Id
    tinyint
    Name
    nvarchar (50)
    Description
    nvarchar (300)
  • SuggestedEdits
    Id
    int
    PostId
    int
    CreationDate
    datetime
    ApprovalDate
    datetime
    RejectionDate
    datetime
    OwnerUserId
    int
    Comment
    nvarchar (800)
    Text
    nvarchar (max)
    Title
    nvarchar (250)
    Tags
    nvarchar (250)
    RevisionGUID
    uniqueidentifier
  • SuggestedEditVotes
    Id
    int
    SuggestedEditId
    int
    UserId
    int
    VoteTypeId
    tinyint
    CreationDate
    datetime
    TargetUserId
    int
    TargetRepChange
    int
  • Tags
    Id
    int
    TagName
    nvarchar (35)
    Count
    int
    ExcerptPostId
    int
    WikiPostId
    int
    IsModeratorOnly
    bit
    IsRequired
    bit
  • TagSynonyms
    Id
    int
    SourceTagName
    nvarchar (35)
    TargetTagName
    nvarchar (35)
    CreationDate
    datetime
    OwnerUserId
    int
    AutoRenameCount
    int
    LastAutoRename
    datetime
    Score
    int
    ApprovedByUserId
    int
    ApprovalDate
    datetime
  • Votes
    Id
    int
    PostId
    int
    VoteTypeId
    tinyint
    UserId
    int
    CreationDate
    datetime
    BountyAmount
    int
  • VoteTypes
    Id
    tinyint
    Name
    nvarchar (50)
Revisions

Enter Parameters

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