Joins
Inner Joins
1. Return the names (first and last) and emails of every registered user.
2. Do the same query based on the old style "where" based syntax.
3. List the customer names, the license plate, the vehicle make and year of every registered customer.
4. List the customer name, the license plate, the vehicle make and year and the services provided for the Vehicle service with the ID of 12.
5. List the location names and the names of all the employees that work at those locations.
Cross Joins
6. Do a cross join between Person and registered customer. Use the cross Join syntax.
7. Do a cross join using the older syntax
Outer Joins
8. List the customers people that do not have a registered customer account.
9. List any location names that has never provided a service for any car
What I am looking for
I want to see the SQL that would provide the data to the query. Each one is worth 1 pt. with one point for free for a total of 10 points.
To Turn in
Copy the SQL into a Google doc. Share it with spconger@gmail.com
No comments:
Post a Comment