WITH acceptedansers AS (SELECT acceptedanswer.id, CASE WH...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Reverse Engineering Meta

Q&A about the site for researchers and developers who explore the principles of a system through analysis of its structure, function, and operation

WITH acceptedansers 
     AS (SELECT acceptedanswer.id, 
                CASE 
                  WHEN reputation < 15 THEN 1 
                  ELSE 0 
                END AS newuser, 
                CASE 
                  WHEN reputation >= 15 THEN 1 
                  ELSE 0 
                END AS expuser, 
                CASE 
                  WHEN acceptedanswer.score = 0 THEN 'Zero Accepted Answer' 
                  ELSE 'Zero Accepted Answer' 
                END AS TYPE ,
acceptedanswer.score
         FROM   posts question 
                INNER JOIN posts acceptedanswer 
                  ON question.acceptedanswerid = acceptedanswer.id 
                INNER JOIN users u 
                  ON question.owneruserid = u.id 
         WHERE  question.posttypeid = 1) 
SELECT top 10 * from acceptedansers 

Enter Parameters

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