structured query language math

posted by .

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;

  • structured query language math -

    DFSDFGF

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. testing and selection of dogs

    please check this for me thank you Why should obedience instructors refuse to treat extremely aggressive dogs?
  2. 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?
  3. math

    In how many ways can 8 instructors be assigned to five sections of a course in mathematics
  4. 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, …
  5. 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 …
  6. 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 …
  7. Math

    In how many ways can 10 instructors be assigned to seven sections of a course in mathematics?
  8. Math

    In how many ways can 8 instructors be assigned to five sections of a course in mathematics?
  9. edu

    Which of the following statements is true?
  10. 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 …

More Similar Questions