Question: Question; Some instructors are mentors for other instructors. Write a SQL query to list the instructor ID for each of the mentors and a count

Question; Some instructors are mentors for other instructors. Write a SQL

Question; Some instructors are mentors for other instructors. Write a SQL query to list the instructor ID for each of the mentors and a count of how many instructors they mentor.

INSTRUCTOR_ID INSTRUCTOR_NAME SALARY COMMISSION MENTOR_ID DATE_HIRED 835 SPARKS 4000 200 978 16-DEC-84 978 STEEL 5000 250 222 16-JAN-80 222 CAINE 5500 350 02-NOV-76 243 TUCKER 2000 835 18-DEC-90 263 JOHNSON 4000 - 835 18-JUL-92 515 SHELLEY 3500 200 700 20-JAN-91 453 LODGE 2500 100 835 14-SEP-88 700 WAYNE 4500 300 16-MAY-81 628 MONROE 3000 700 16-JUL-84 790 NEWMAN 3100 300 700 16-DEC-82 795 BOGART 3200 700 16-DEC-83 560 LAUREL 5200 200 978 16-DEC-83 123 FLINTSTONE, FRED _ 1000 978 16-JUN-89

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Define the contextual-equivalence relation ` M =ctx M0 : for pairs of PCF terms M, M0 , PCF types , and PCF type environments . [3 marks] (ii) For PCF terms M and N with respective typings ` M : and...

First of all, have a look at the SQL database creation and population code that accompanies this assignment. All questions and items in this assignment pertain to the SQL code that accompanies this...

Write SQL queries to compute the following information ( note : you are not allowed to use in , exists , forall , intersect , diff , union , or except ): 1- What is the name of faculty member whose...

Describe the purpose of hash functions, message authentication codes and digital signatures, sketching a possible construction for each of them. [12 marks] A funds transfer system authenticates...

Can anyone helps me with this SQL. 1- Write a SQL query to display list of unique first and last names of students, admins and instructors. 2-Write a SQL query to display list of employee IDs along...

( /2 marks) Give the SQL query to list all the section information.\ ( /2 marks) Give the SQL statement to list all the student names with their department and department building. Sort the results...

Number 5 please. What do I type in SQL so that I can get the result in number 5? Here are the tables: Problems and Exercises 1 through 5 are based on the class schedule 3NF relations along with some...

Project Description: Please write SQL queries to update tables extract the following information. Write your queries based on the database you developed in the previous project. For each question,...

write an sql query for the following questions 4. Write a script that uses two variables to store (1) the count of all of the instructors in the Instructors table and (2) the average annual salary...

1- Prepare the journal entries to record the above transactions. 2-Prepare the statement of retained earnings for the year. 3-Prepare the stockholders equity section of the balance sheet as of...

Solve the Recurrence Relation given below. 6n T(n) = 7/7 + 7 + n Note: Please provide all the intermediate steps while solving this recurrence relation

In this task, you are required to balance the funding position below to meet the needs and requirements of Natasha. You must consider requirements specific to Natasha's email to work out the correct...

Escriba los nombres de los siguientes compuestos usando la nomenclatura IUPAC. a b c d e f Dibuje la estructura de los siguientes compuestos Acido 4 - etil - 2 - propiloctanoico m -...

Holding national saving constant, does an increase in net capital outflow increase, decrease, or have no effect on a countrys accumulation of domestic capital?

An article in USA Today (December 16, 2004) began President Bush said Wednesday that the White House will shore up the sliding dollar by working to cut record budget and trade deficits. a. According...

International trade in each of the following products has increased over time. Suggest some reasons this might be so. a. wheat b. banking services c. computer software d. automobiles