SQL201

Here are the solutions to the homework problems I sent out.  Compare my queries with yours.  If they’re different, and you’d like some explanation on why they’re different.  Let me know.  I’ll be happy to explain any differences with you. 1. Give me a list of all the first and last names in both tables. …

Read More SQL Homework—UNION, INTERSECT, EXCEPT—Solutions

This homework will run from my training server, shaioshin.hopto.org.  If you do not currently have access to this server, please let me know and I’ll set up credentials so you can complete the following homework assignment. In the AdventureWorks database on my server I have two tables: example.person and person.contact.  Take a look at the…

Read More SQL Homework–UNION, INTERSECT, EXCEPT