0

Please login or register to vote for this query.

(click on this box to dismiss)

based on http://data.stackexchange.com/stackoverflow/s/2312 improved with user links

Q&A for people who build and repair bicycles, people who train cycling, or commute on bicycles

-- 50 suggested edits per day

SELECT  ownerUserid as [User Link], cast(creationdate as date) creationday, count(id) editcount,
SUM(case WHEN  ApprovalDate is not null then 1 else 0 end) approval,
SUM(case WHEN  RejectionDate is not null then 1 else 0 end) Rejection
FROM SuggestedEdits
GROUP BY ownerUserid, cast(creationdate as date) 

HAVING count(ID) > 50
ORDER BY count(id)   desc 

fork query

created dec 20 11 burpenator