0

Please login or register to vote for this query.

(click on this box to dismiss)

My scores from questions and answers

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

-- Question rep vs Answer rep
-- My scores from questions and answers

SELECT
   case 
   when p.PostTypeId = 1 then
       'Question'
   else
       'Answer'
   end as 'Post Type',
   case 
   when p.PostTypeId = 1 then 
       SUM(p.Score) * 5 
   when p.PostTypeId = 2 then
       SUM(p.Score) * 10 
   end as 'Score'
   
FROM
  Posts p
WHERE
  p.OwnerUserId = 12725
GROUP BY p.PostTypeId

fork query

created aug 18 10 James.C