0
What does the following query return (two columns)?
CREATE TABLE a(x INT); INSERT INTO a VALUES (1),(2),(2);
CREATE TABLE b(x INT); INSERT INTO b VALUES (2),(3);
SELECT (SELECT COUNT(*) FROM (SELECT x FROM a UNION SELECT x FROM b) AS t1),
(SELECT COUNT(*) FROM (SELECT x FROM a UNION ALL SELECT x FROM b) AS t2);- A3 3
- B5 3
- C5 5
- D3 5
Correct answer: D