2 ms·
Because it’s a (worse) variant of one of the first queries the article gives: SELECT *, COUNT(*) FROM t1 GROUP BY x, y, z, ... -- all attributes of t
by Someone 3y ago
Because it’s a (worse) variant of one of the first queries the article gives:
SELECT *, COUNT(*)
FROM t1
GROUP BY x, y, z, ... -- all attributes of t1
EXCEPT
SELECT *, COUNT(*)
FROM t2
GROUP BY x, y, z, ... -- all attributes of t2
and we aren’t discussing ChatGPT here.