0
What is the output of the following SQL statements?
CREATE TABLE emp(id INT, name TEXT, mgr INT);
INSERT INTO emp VALUES (1,'A',NULL),(2,'B',1),(3,'C',1),(4,'D',2),(5,'E',2),(6,'F',3),(7,'G',2);
SELECT COUNT(*) FROM emp x JOIN emp y ON x.mgr = y.mgr AND x.id < y.id;- A8
- B3
- C4
- D5
Correct answer: C