What is the output of the following SQL query?CREATE TABLE c(id INT, name TEXT); INSERT INTO c VALUES (1,'A'),(2,'B'),(3,'C'); CREATE TABLE…

What is the output of the following SQL query?

CREATE TABLE c(id INT, name TEXT);
INSERT INTO c VALUES (1,'A'),(2,'B'),(3,'C');
CREATE TABLE o(id INT, cid INT, amt INT);
INSERT INTO o VALUES (1,1,100),(2,1,50),(3,3,70);
SELECT c.name, COUNT(o.id) FROM c LEFT JOIN o
ON c.id = o.cid GROUP BY c.name ORDER BY c.name;