Write a CTE statement that returns the following information

 

All Instructor with a First Name starting with the letter 'G' teaching courses for the business department only

 

 

Then, write a SELECT statement that uses this CTE to return all the students who are enrolled in the courses which are taught by the instructor returned in the above CTE.

 

Select should return following information:

 

Instrucor Name( FirstName LastName)

DepartmentName

CourseID

CourseDescription

Student Name (FirstName LastName)

Write a SELECT statement that answers this question: What is the total number of courses taught by Full-time instructors? Return these columns:

 

The instructor's name in this format

FirstName Lastname

The total number of courses taught by each instructor

 

Use any operator to return each group total and a grand total of the selection.

 

 

 

 

Write a Query to return all the students who graduated successfully. Write a SELECT statement that returns the following information :

 

First Name

Last Name

Course Number

Course Description

Graduation Date

 

Sort the result set by Course Number, then by the Graduation Date.

 

 

Write a stored procedure that inputs StudentID and returns the total tuition fee for the input student.

Input Parameter : StudentID

Return Tuition Fee.

 

#1 Show the definition of the Store Procedure

#2 Show the execution of the Stored Procedure( Calling the store procedure and displaying the tuition of the Student)