1. Create a procedure called usp_10 to automate the query you wrote above for problem #1 in the last lab. Write the procedure so that the person running the procedure can specify any job type.

This is not working ----

CREATE PROCEDURE usp_10 (@job_type char(15))

AS SELECT w.emp_no,w.job

FROM (SELECT * FROM Works_on WHERE job=@job_type) as w

INNER JOIN (SELECT project_no from Project WHERE project_name='Gemini') as p ON w.project_no=p.project_no;

The original statement used---

SELECT a.emp_no,a.job

FROM works_on as a INNER JOIN (SELECT project_no from Project

WHERE project_name='Gemini') as p ON a.project_no=p.project_no;

11. Create a procedure called usp_11 to automate the query you wrote above for problem #1. Write the procedure so that the person running the procedure can specify any project name (not project number).

This is not working ---

CREATE PROCEDURE usp_11 (@project_name char(15))

AS

SELECT w.emp_no,w.job FROM Works_on as w INNER JOIN

(SELECT project_no from Project WHERE project_name=@project_name) as p ON

w.project_no=p.project_no;

The original statement used---

SELECT a.emp_no,a.job

FROM works_on as a INNER JOIN (SELECT project_no from Project

WHERE project_name='Gemini') as p ON a.project_no=p.project_no;