What is the output of the following SQL query?CREATE TABLE dept(id INT, name TEXT); CREATE TABLE emp(id INT, name TEXT, dept_id INT); INSER…

What is the output of the following SQL query?

CREATE TABLE dept(id INT, name TEXT);
CREATE TABLE emp(id INT, name TEXT, dept_id INT);
INSERT INTO dept VALUES (1,'HR'),(2,'IT'),(3,'Ops');
INSERT INTO emp VALUES (1,'Ann',1),(2,'Bob',2),
                       (3,'Cid',2),(4,'Dee',2);
SELECT d.name, COUNT(e.id) FROM dept d
LEFT JOIN emp e ON e.dept_id = d.id
GROUP BY d.name ORDER BY d.name;