Multiplication: Identify the SQL that answer this question:

What are all the possible combinations of pets and owners?

Join: Identify the SQL that answers each of the following questions:

Who are the pets and who are their owners? What are the pet names, species, breeds, and owner names? What are the pet ID's and owner ID's?

Outer Join: Identify the SQL that answers each of the following questions:

Who are the pets and their owners, as well as people without pets? What are the pet ID's and owner ID's of the pets and their owners, as well as people without pets? What are the pet names, species, breeds, and owner names of the pets and their owners, as well as people without pets? Who are the pets and their owners, as well animals without owners? What are the pet ID's and owner ID's of the pets and their owners, as well animals without owners?

Notice these require all tables used in the SQL command to have the same ATTRIBUTES. In other words, the table structures must be identical these are often used either to append data to a table or to make a check on data in a table.

Union: Identify the SQL that answers each of the following questions:

Who are the shelter animals and registered pets? What are ID numbers of the registered pets as well as the shelter animals?

Intersection: Identify the SQL that answers each of the following questions:

What registered pets are from the shelter? What are the ID numbers of the registered pets that are from the shelter?

Difference: Identify the SQL that answers each of the following questions:

What shelter animals are not registered pets? What are the ID numbers of the registered pets not from the shelter?