Create store procedure that receives first name of employees


Problem

A. Create a stored procedure (JobIDEmployeeCountSEL) that will receive the JobId and list JobId,JobTitle, MinSalary,MaxSalary, and the number of employees for that Job with a minimum of 3 employees.

B. Create a view (vRegionIdCoutntriesCount) to list all the regionId with the number of countries in that region.

C. Create a Stored procedure (MaxMinSalaryPerJobIdSEL) that receives jobId, and list the maximum and minimum salary.

D. Create a store procedure (LastNameSEL) that receives the first name of the employee from the Employees table as input produce the last name as output.

Request for Solution File

Ask an Expert for Answer!!
Database Management System: Create store procedure that receives first name of employees
Reference No:- TGS03242703

Expected delivery within 24 Hours