February 26, 2017

Homework Help: SQL

Posted by joe on Friday, July 22, 2011 at 10:45pm.

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.
b) Write the same query as above, but using a scalar subquery,without outerjoin.

Answer This Question

First Name:
School Subject:

Related Questions

More Related Questions