Posted by **joe** on Saturday, July 23, 2011 at 8:06pm.

Display a list of all instructors, showing their ID, name, and the number of sections that they have taught. Make sure to show the number of sections as 0 for instructors who have not taught any section. Your query should use an outerjoin, and should not use scalar subqueries.

Is this the right answer:

select ID, name

from instructor natural left outer join

section

where sec_id = ID

having count (instr_id) > = 0;

## Answer This Question

## Related Questions

- SQL - Display a list of all instructors, showing their ID, name, and the number ...
- math write in sql - I have this question i need to know how to do for a test ...
- math write in sql - Display the list of all departments, with the total number ...
- Mat 126 - A community college has 3,000 students and 90 instructors. The college...
- testing and selection of dogs - please check this for me thank you Why should ...
- Math - In how many ways can 8 instructors be assigned to five sections of a ...
- math - In how many ways can 8 instructors be assigned to five sections of a ...
- Math - In how many ways can 10 instructors be assigned to seven sections of a ...
- programing - 3.Write a query to display the annual salary of all employees in ...
- programing - 5.Write a query to display the details of employees in the shipping...

More Related Questions