Use the actual words in the query. For example in 6.23 use the word "Gemini", not the project number in order to avoid joining the tables. Remember, the purpose of this is to practice joins and subqueries

Do each of these exercises twice: once with a join and once with a subquery. 6.23, 6.24, 6.25,

Other remains exercise just once 6.17, 6.27

2. Write a query to list all employees (all columns) and their jobs on various projects. Include employees that do not work on any jobs. QUESTION: Who does not work on any jobs? Procedures: 3. Create a procedure called usp_3 to automate the query you wrote above for exercise E.6.2 in the last lab. Write the procedure so that the person running the procedure can specify any job type. 4. Create a procedure called usp_4 to automate the query you wrote above for exercise E.6.23. Write the procedure so that the person running the procedure can specify any project name (not number). To view procedures you have created you can run the command: select * from sysobjects where type='p' /* p stands for procedure */