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

Transcribed Image Text:

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 */ 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 */

Answer rating: 100% (QA)

Based on the information provided and the images you shared it seems the instructions are related to practicing SQL queries specifically JOINs and sub... View the full answer