Your query exercise for this week was to write a query to find users created in the last 90 days, with a reputation higher than 50 points, from highest reputation to lowest. Because everyone’s Stack Overflow database might be slightly different, we had to start by finding the “end date” for our query. I’m working with the 2018-06 export that I use in my training classes, so here’s my end date:
So if I’m looking for that date range, here’s the query I came up with:
SELECT TOP 1000 Id AS UserId FROM dbo.Users WHERE CreationDate > DATEADD(dd, -90, ‘2018-06-03