Q&A for those who study, teach, research and apply economics and econometrics
SELECT Users.Id, Users.Reputation, Users.DisplayName, Badges.Date As BadgeDate, Posts.Id AS PostId, Posts.CreationDate AS PostDate, Votes.VoteTypeId AS VoteId, Votes.CreationDate AS VoteDate INTO #tmp FROM Users LEFT JOIN Badges ON Users.Id = Badges.UserId LEFT JOIN Posts ON Users.Id = Posts.OwnerUserId LEFT JOIN Votes ON Posts.Id = Votes.PostId WHERE Badges.Name='Mortarboard' AND Votes.VoteTypeId=2 AND CAST(Badges.Date AS DATE)=Votes.CreationDate AND CAST(Posts.CreationDate AS DATE)!=Votes.CreationDate; SELECT * FROM #tmp ORDER BY Id DESC, PostId; --GROUP BY Users.Id HAVING COUNT(*) > 15;