structured query language math

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;

  1. 👍 0
  2. 👎 1
  3. 👁 504
asked by joe
  1. DFSDFGF

    1. 👍 0
    2. 👎 0
    posted by DDFDSF

Respond to this Question

First Name

Your Response

Similar Questions

  1. 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

    asked by joe on July 22, 2011
  2. 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

    asked by joe on July 23, 2011
  3. 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

    asked by joe on July 23, 2011
  4. 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? 13

    asked by Derek on October 10, 2010
  5. testing and selection of dogs

    please check this for me thank you Why should obedience instructors refuse to treat extremely aggressive dogs? A. Instructors don't have the right protective equipment to work with biting dogs. B. Obedience instructors aren't

    asked by Anonymous on June 26, 2008
  6. math

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

    asked by kozy on June 7, 2011
  7. Math

    In how many ways can 10 instructors be assigned to seven sections of a course in mathematics? would it be 10/7 = 1.43??

    asked by Jen on July 28, 2011
  8. Math

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

    asked by Melissa on July 31, 2011
  9. 5th grade math

    A list of numbers represents the following pattern: For each number after the first, multiply the previous number by itself, and then subtract that number. Which list does NOT represent that pattern? A. 1,1,1,1, and so on B.

    asked by jamar on January 15, 2014
  10. Math

    Create a Raptor Flowchart that calculates the amount a person would earn over a period of time if his or her salary were five cents the first day, ten cents the second day, and so on doubling each day. Your program should: 1.

    asked by Morgan on February 23, 2017

More Similar Questions