My PostgreSQL Quiz

The ultimate place to learn PostgreSQL!

Question #4: What is output by the SQL below?

DROP SCHEMA IF EXISTS foo CASCADE;
DROP SCHEMA IF EXISTS koo CASCADE;
CREATE SCHEMA foo;
CREATE SCHEMA koo;
CREATE TABLE koo.foo (a INT, b INT, c INT);
CREATE TABLE foo.foo (a INT, b INT, c INT);
INSERT INTO foo.foo VALUES (1,2,3);
INSERT INTO koo.foo SELECT * FROM koo.foo;
INSERT INTO koo.foo SELECT * FROM koo.foo;
SELECT sum(b) FROM foo.foo;