sql experts
sql experts
Out of context: Reply #1
- Started
- Last post
- 4 Responses
- flavorful0
SELECT user_id AS pass_id, COUNT( question_id ) AS correct
FROM contest_answers
WHERE
( (question_id IN ( 110, 111, 112, 113 )) AND (question_id NOT IN (110, 111, 113, 200)))
GROUP BY user_id
HAVING correct = '4'----
?
This should only include their "correct" answers and should bar any "incorrect" answers.