Wednesday
July 30, 2014

Homework Help: structured query language math

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

First Name:
School Subject:
Answer:

Related Questions

SQL - Display a list of all instructors, showing their ID, name, and the number ...
math write in sql - Display the list of all departments, with the total number ...
programing - 3.Write a query to display the annual salary of all employees in ...
math write in sql - I have this question i need to know how to do for a test ...
programing - 5.Write a query to display the details of employees in the shipping...
computer science - What is a type of operator that uses the AND, OR, and NOT? I'...
programming - 1.Write a query to display the names of the employees that do not ...
edu - Which of the following statements is true? a.Language is learned only when...
Intro to Computer Programming - Pseudocode - This assignment (below) jumped way ...
5th grade math - A list of numbers represents the following pattern: For each ...

Search
Members