IT 125 - Nicole Cook - Assignment 4

Assignment 4 -- Creating Simple Joins
This assignment teaches you how to create simple joins -- please use MySQL Workbench
	You will be using your hobby database for both this assignment and the hybrid assignment. Using your existing tables: Create a simple 2 table inner join Create a 2 table join with an additional WHERE clause (This WHERE clause is not part of the JOIN) Create a query that performs a join but returns only 1 useful field from each table joined. By useful here, I mean the data is meaningful and makes sense. Save your script Run your script and take a screenshot of it working with no errors

Assignment 4 -- Creating Simple Joins

This assignment teaches you how to create simple joins -- please use MySQL Workbench

You will be using your hobby database for both this assignment and the hybrid assignment.

Using your existing tables:

Create a simple 2 table inner join
Create a 2 table join with an additional WHERE clause
(This WHERE clause is not part of the JOIN)
Create a query that performs a join but returns only 1 useful field from each table joined. By useful here, I mean the data is meaningful and makes sense.
Save your script

Run your script and take a screenshot of it working with no errors

Hybrid Class Assignment -- Creating Advanced Joins
This assignment teaches you how to create advanced joins

	For the hybrid part, still using your hobby database, do the following: Write a join that connects more than 2 tables Write an outer join to look for missing data Write a join that uses both: A join that is not an inner join A WHERE clause to limit the data returned Save your script Run your script and take a screenshot of it working with no errors

Assignment Submission Criteria
To turn in this assignment you will go to the NSC Canvas shell for this class and submit the followinig as attachments: Your .sql script file(s) Screenshots of your output (working without errors)