0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Japanese language

-- AVG Accept Rep
-- Enter Query Description

Select 
   case WHEN AcceptedAnswerId  is null then 'Not Accepted' ELSE 'Accepted' END as  AcceptFlag,
   SUM(cast(u.reputation as bigint))    as  acceptrep

FROM posts p
inner join users u on p.OwnerUserId = u.id
GROUP BY case WHEN AcceptedAnswerId  is null then 'Not Accepted' ELSE 'Accepted' END 

fork query

created sep 23 11 jon.doe60