math write in sql

posted by .

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 one instructor, it should appear as many times in the result as it has instructors. If it does not have any instructor, it should still appear in the result with the instructor name set to "__".

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. programming

    1.Write a query to display the names of the employees that do not have any department_id. 2. Write a query to display the names, salary and job_id of employees in department_id 40, 60 and 80. Display the name as a single column and …
  2. programing

    3.Write a query to display the annual salary of all employees in department_id 20. Display the names in increasing order or salary. 4.Write a query to display the average salary of employees. Label the column as ' Average Salary. 5.Write …
  3. 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, …
  4. 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 …
  5. 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, …
  6. programming

    Write a program reads the city names and respective gas prices into 2 single-subscripted arrays in your program - one of type string, the other of type double. (We would call these "parallel arrays" - each corresponding location shows …
  7. Math

    RD – z, t, or Chi-Square Test Study Background During this week you will work in your group discussion area to identify a research question created in week 1 that would utilize any of the following: z test, t test for single sample, …
  8. Math

    RD – z, t, or Chi-Square Test Study Background During this week you will work in your group discussion area to identify a research question created in week 1 that would utilize any of the following: z test, t test for single sample, …
  9. Computer science

    Need help on how write this program. "The Eversoft Eraser Company has a list of its customers’ names (not necessarily in alphabetical order) and telephone numbers in a file named "customer" with records of the following form: last_name …
  10. Java

    Need help asap. You are given a list of students' names and their test scores. Design an algorithm that does the following: a. Calculates the average test scores. b. Determines and print the names of all the students whose test score …

More Similar Questions