In-Class Exercise 5 Name:

CIS 360 - Business Database Concepts - SQL Joins

For the following problems, put screen shots from SQL Server showing both your SQL code and the output. Use table and column aliases where appropriate. Type your name in the box above. Save this file as "FirstInitialLastname-ICJOINS.pdf" and submit to blackboard by the due date and time. (i.e. lprince-ICJOINS.pdf)

1. What is Alice Johnson's job title?

2. We're starting a new project and need to know the names of our systems analysts and applications designers. Include last names labeled Employee and job titles labelled Title.

3. What is the last name labeled Manager and job description (Job) of each person managing a project? Include the project name and label it In Charge of.

4. List the last name of all employees currently working on a project. Include the name of the project labeled Working On. Do not include duplicates.

5. Name the employees (first and last name) who worked more than 5 hours on a job? Include the job number and number of hours worked (More than 5 hours). You do not need to total hours per job.

6. What is the total number of hours worked so far on the Rolling Tide project? Label as Total Hours on Rolling Tide Project.

7. How many employees are working on the Rolling Tide project? Label the output

Total Employees on Rolling Tide.