Stack Exchange
log in
help
Stack Exchange Data Explorer
Home
Queries
Users
Compose Query
Editing Query
edit description
Q&A for experienced flyers, pilots, and builders of drones and model aircraft
SELECT TOP 10 OwnerUserId [User Link], AVG(Score) FROM Posts p GROUP BY OwnerUserId HAVING COUNT(*) > 100 AND AVG(Score) > (SELECT AVG(Score) FROM Posts WHERE OwnerUserId = 22656) AND (SELECT Reputation FROM Users u WHERE OwnerUserId = u.Id) > 100 ORDER BY AVG(Score) DESC
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
115796
Aarthi
feb 8 '13 at 23:48
115795
Aarthi
feb 8 '13 at 23:47
115794
Aarthi
feb 8 '13 at 23:46
115793
Aarthi
feb 8 '13 at 23:46
115792
Aarthi
feb 8 '13 at 23:45
115791
Aarthi
feb 8 '13 at 23:45
115788
Aarthi
feb 8 '13 at 23:44
115787
Aarthi
feb 8 '13 at 23:44
115786
Aarthi
feb 8 '13 at 23:43
115724
Aarthi
feb 8 '13 at 21:56
115723
Aarthi
feb 8 '13 at 21:54
115720
Aarthi
feb 8 '13 at 21:45
115381
Aarthi
feb 7 '13 at 22:55
115380
Aarthi
feb 7 '13 at 22:54
115379
Aarthi
feb 7 '13 at 22:52
115378
Aarthi
feb 7 '13 at 22:51
115377
Aarthi
feb 7 '13 at 22:50
115369
Aarthi
feb 7 '13 at 22:14
115368
Aarthi
feb 7 '13 at 22:14
115367
Aarthi
feb 7 '13 at 22:14
115366
Aarthi
feb 7 '13 at 22:12
115365
Aarthi
feb 7 '13 at 22:12
115364
Aarthi
feb 7 '13 at 22:11
115363
Aarthi
feb 7 '13 at 22:11
115362
Aarthi
feb 7 '13 at 22:10
115361
Aarthi
feb 7 '13 at 22:10
115350
Aarthi
feb 7 '13 at 21:43
115349
Aarthi
feb 7 '13 at 21:43
115348
Aarthi
feb 7 '13 at 21:41
115347
Aarthi
feb 7 '13 at 21:40
115346
Aarthi
feb 7 '13 at 21:39
115344
Aarthi
feb 7 '13 at 21:39
115343
Aarthi
feb 7 '13 at 21:38
115038
Aarthi
feb 7 '13 at 0:55
115037
Aarthi
feb 7 '13 at 0:52
115036
Aarthi
feb 7 '13 at 0:52
115035
Aarthi
feb 7 '13 at 0:51
115034
Aarthi
feb 7 '13 at 0:49
115033
Aarthi
feb 7 '13 at 0:48
115024
Aarthi
feb 7 '13 at 0:22
115023
Aarthi
feb 7 '13 at 0:22
115022
Aarthi
feb 7 '13 at 0:22
115020
Aarthi
feb 7 '13 at 0:03
115019
Aarthi
feb 7 '13 at 0:02
114658
Aarthi
feb 6 '13 at 16:44
114656
Aarthi
feb 6 '13 at 16:41
114654
Aarthi
feb 6 '13 at 16:41
114653
Aarthi
feb 6 '13 at 16:41
114652
Aarthi
feb 6 '13 at 16:41
114650
Aarthi
feb 6 '13 at 16:40
114649
Aarthi
feb 6 '13 at 16:39
114648
Aarthi
feb 6 '13 at 16:39
114646
Aarthi
feb 6 '13 at 16:39
114645
Aarthi
feb 6 '13 at 16:39
114622
Aarthi
feb 6 '13 at 16:10
114621
Aarthi
feb 6 '13 at 16:10
114620
Aarthi
feb 6 '13 at 16:10
114619
Aarthi
feb 6 '13 at 16:09
114618
Aarthi
feb 6 '13 at 16:09
114617
Aarthi
feb 6 '13 at 16:09
114616
Aarthi
feb 6 '13 at 16:08
114614
Aarthi
feb 6 '13 at 16:08
114611
Aarthi
feb 6 '13 at 16:07
111353
Aarthi
jan 23 '13 at 23:23
111352
Aarthi
jan 23 '13 at 23:22
111351
Aarthi
jan 23 '13 at 23:20
111350
Aarthi
jan 23 '13 at 23:20
111349
Aarthi
jan 23 '13 at 23:19
111346
Aarthi
jan 23 '13 at 23:15
111345
Aarthi
jan 23 '13 at 23:15
111341
Aarthi
jan 23 '13 at 23:02
111340
Aarthi
jan 23 '13 at 23:02
111339
Aarthi
jan 23 '13 at 23:02
111338
Aarthi
jan 23 '13 at 23:02
111337
Aarthi
jan 23 '13 at 23:02
111330
Aarthi
jan 23 '13 at 22:51
111329
Aarthi
jan 23 '13 at 22:51
111327
Aarthi
jan 23 '13 at 22:50
111326
Aarthi
jan 23 '13 at 22:49
111325
Aarthi
jan 23 '13 at 22:49
111324
Aarthi
jan 23 '13 at 22:46
111323
Aarthi
jan 23 '13 at 22:46
111322
Aarthi
jan 23 '13 at 22:45
111310
Aarthi
jan 23 '13 at 22:16
111305
Aarthi
jan 23 '13 at 22:13
111304
Aarthi
jan 23 '13 at 22:13
111303
Aarthi
jan 23 '13 at 22:13
110982
Aarthi
jan 23 '13 at 19:49
110981
Aarthi
jan 23 '13 at 19:48
110980
Aarthi
jan 23 '13 at 19:46
110979
Aarthi
jan 23 '13 at 19:46
110965
Aarthi
jan 23 '13 at 18:59
110964
Aarthi
jan 23 '13 at 18:58
110963
Aarthi
jan 23 '13 at 18:56
110962
Aarthi
jan 23 '13 at 18:55
110961
Aarthi
jan 23 '13 at 18:55
110960
Aarthi
jan 23 '13 at 18:54
110959
Aarthi
jan 23 '13 at 18:53
110958
Aarthi
jan 23 '13 at 18:53
110957
Aarthi
jan 23 '13 at 18:52
110956
Aarthi
jan 23 '13 at 18:51
110955
Aarthi
jan 23 '13 at 18:51
110951
Aarthi
jan 23 '13 at 18:39
108698
Aarthi
jan 11 '13 at 19:27
108697
Aarthi
jan 11 '13 at 19:27
108695
Aarthi
jan 11 '13 at 19:26
108694
Aarthi
jan 11 '13 at 19:26
108693
Aarthi
jan 11 '13 at 19:24
108692
Aarthi
jan 11 '13 at 19:23
108687
Aarthi
jan 11 '13 at 19:20
108685
Aarthi
jan 11 '13 at 19:19
108680
Aarthi
jan 11 '13 at 19:17
108678
Aarthi
jan 11 '13 at 19:17
108672
Aarthi
jan 11 '13 at 19:14
108665
Aarthi
jan 11 '13 at 19:10
108662
Aarthi
jan 11 '13 at 18:48
108661
Aarthi
jan 11 '13 at 18:48
108659
Aarthi
jan 11 '13 at 18:46
108658
Aarthi
jan 11 '13 at 18:46
108657
Aarthi
jan 11 '13 at 18:46
103541
Aarthi
dec 7 '12 at 18:26
103535
Aarthi
dec 7 '12 at 18:24
103534
Aarthi
dec 7 '12 at 18:23
103419
Aarthi
dec 6 '12 at 22:56
103418
Aarthi
dec 6 '12 at 22:56
103416
Aarthi
dec 6 '12 at 22:53
103415
Aarthi
dec 6 '12 at 22:45
103414
Aarthi
dec 6 '12 at 22:44
103413
Aarthi
dec 6 '12 at 22:20
103412
Aarthi
dec 6 '12 at 22:20
103411
Aarthi
dec 6 '12 at 22:02
103410
Aarthi
dec 6 '12 at 22:02
103406
Aarthi
dec 6 '12 at 21:48
103405
Aarthi
dec 6 '12 at 21:42
103403
Aarthi
dec 6 '12 at 21:10
103402
Aarthi
dec 6 '12 at 21:04
103400
Aarthi
dec 6 '12 at 21:01
103399
Aarthi
dec 6 '12 at 21:01
103398
Aarthi
dec 6 '12 at 20:59
103397
Aarthi
dec 6 '12 at 20:58
103396
Aarthi
dec 6 '12 at 20:57
103395
Aarthi
dec 6 '12 at 20:57
103394
Aarthi
dec 6 '12 at 20:56
103393
Aarthi
dec 6 '12 at 20:56
103391
Aarthi
dec 6 '12 at 20:55
103385
Aarthi
dec 6 '12 at 20:53
103381
Aarthi
dec 6 '12 at 20:52
103150
Aarthi
dec 5 '12 at 22:47
103133
Aarthi
dec 5 '12 at 22:27
103131
Aarthi
dec 5 '12 at 22:26
103130
Aarthi
dec 5 '12 at 22:25
103129
Aarthi
dec 5 '12 at 22:24
103128
Aarthi
dec 5 '12 at 22:24
103125
Aarthi
dec 5 '12 at 22:16
103119
Aarthi
dec 5 '12 at 21:40
103118
Aarthi
dec 5 '12 at 21:38
103117
Aarthi
dec 5 '12 at 21:36
103115
Aarthi
dec 5 '12 at 21:36
103113
Aarthi
dec 5 '12 at 21:30
103112
Aarthi
dec 5 '12 at 21:28
103111
Aarthi
dec 5 '12 at 21:28
101760
Aarthi
nov 30 '12 at 2:05
101753
Aarthi
nov 30 '12 at 2:03
101752
Aarthi
nov 30 '12 at 2:02
101750
Aarthi
nov 30 '12 at 1:59
101749
Aarthi
nov 30 '12 at 1:59
101748
Aarthi
nov 30 '12 at 1:59
101747
Aarthi
nov 30 '12 at 1:58
101745
Aarthi
nov 30 '12 at 1:54
101744
Aarthi
nov 30 '12 at 1:49
101743
Aarthi
nov 30 '12 at 1:48
101742
Aarthi
nov 30 '12 at 1:48
101741
Aarthi
nov 30 '12 at 1:47
101740
Aarthi
nov 30 '12 at 1:45
101739
Aarthi
nov 30 '12 at 1:45
101738
Aarthi
nov 30 '12 at 1:45
101737
Aarthi
nov 30 '12 at 1:44
101736
Aarthi
nov 30 '12 at 1:44
101735
Aarthi
nov 30 '12 at 1:43
101734
Aarthi
nov 30 '12 at 1:38
101733
Aarthi
nov 30 '12 at 1:35
101732
Aarthi
nov 30 '12 at 1:35
101731
Aarthi
nov 30 '12 at 1:34
permalink
hide sidebar
Enter Parameters
Run Query
Cancel
Options:
Text-only results
Include execution plan
Switch to main site
Hold tight while we fetch your results
Results
[:current/:total]
Messages
Graph
Execution Plan
Download CSV
Download XML
:records returned in :time ms:cached
Data Explorer works best with JavaScript enabled