select users.id as [User Link], users.reputation, users.c...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select 
	users.id as [User Link], 
	users.reputation, 
    users.creationdate,
	users.upvotes, 
	users.downvotes,
    users.location, 
	users.aboutme
from users
inner join suggestededits 
	on suggestededits.owneruserid = users.id 
	and convert(date, suggestededits.creationdate) = convert(date, users.creationdate)
where 
	users.creationdate > '2018-01-01'
	and reputation >= 15 and reputation < 100
	and upvotes > 30
group by 
	users.id, 
	users.reputation, 
	users.creationdate, 
	users.displayname, 
	users.location, 
	users.aboutme, 
	users.upvotes, 
	users.downvotes
having count(suggestededits.id) >= 3
order by users.upvotes desc

Enter Parameters

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