structured query language math
posted by joe .
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;

DFSDFGF
Respond to this Question
Similar Questions

testing and selection of dogs
please check this for me thank you Why should obedience instructors refuse to treat extremely aggressive dogs? 
Mat 126
A community college has 3,000 students and 90 instructors. The college plans that enrollment will be 3,500 next year. How many new instructors should be hired if the college wants to keep the same student to instructor ratio? 
math
In how many ways can 8 instructors be assigned to five sections of a course in mathematics 
SQL
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, … 
math write in sql
I have this question i need to know how to do for a test coming up this week. a)Display the list of all course sections offered in Spring 2010, along with the names of the instructors teaching the section. If a section has more than … 
math write in sql
Display the list of all departments, with the total number of instructors in each department, without using scalar subqueries. make sure to correctly handle departments with no instructors. Is this the right answer: select department.dept_name … 
Math
In how many ways can 10 instructors be assigned to seven sections of a course in mathematics? 
Math
In how many ways can 8 instructors be assigned to five sections of a course in mathematics? 
edu
Which of the following statements is true? 
math
Organizer of school graduation does have three sections of chairs. 1120 chairs are arranged for graduates, 1400 for invited guests and 896 for lecturers. If all rows have same number of chairs, calculate the greatest number of chairs …