Problem with query SELECT quizzer, COUNT(*) FROM (
SELECT q1 AS quizzer
FROM nationals
WHERE type = 0 OR type = 1
UNION ALL
SELECT q2 AS quizzer
FROM nationals
WHERE type = 0 OR type = 1
UNION ALL
SELECT q3 AS quizzer
FROM nationals
WHERE type = 0 OR type = 1
UNION ALL
SELECT q4 AS quizzer
FROM nationals
WHERE type = 0 OR type = 1
UNION ALL
SELECT q5 AS quizzer
FROM nationals
WHERE type = 0 OR type = 1
UNION ALL
SELECT q1 AS quizzer
FROM nationalspast
WHERE type = 0 OR type = 1
UNION ALL
SELECT q2 AS quizzer
FROM nationalspast
WHERE type = 0 OR type = 1
UNION ALL
SELECT q3 AS quizzer
FROM nationalspast
WHERE type = 0 OR type = 1
UNION ALL
SELECT q4 AS quizzer
FROM nationalspast
WHERE type = 0 OR type = 1
UNION ALL
SELECT q5 AS quizzer
FROM nationalspast
WHERE type = 0 OR type = 1
) results
WHERE results.quizzer IN (SELECT q1 AS quizzer16
FROM nationals
WHERE type = 0 OR type = 1
UNION ALL
SELECT q2 AS quizzer16
FROM nationals
WHERE type = 0 OR type = 1
UNION ALL
SELECT q3 AS quizzer16
FROM nationals
WHERE type = 0 OR type = 1
UNION ALL
SELECT q4 AS quizzer16
FROM nationals
WHERE type = 0 OR type = 1
UNION ALL
SELECT q5 AS quizzer16
FROM nationals
WHERE type = 0 OR type = 1)
GROUP BY results.quizzer ORDER BY results.quizzer;
<br/>ERROR:  relation "nationals" does not exist
LINE 3: FROM nationals
             ^