Using a set operator create a query that will show those players who have not been assigned a team yet. Include in your query the first and last name of the player. Your output should look like the following:

first_name last_name

--------------- -------------------------

Jacob Gregory

Jeff Gregory

Using a set operator create a query that will show those teams who have won games AND were also the home team. Order your output by team name. My output looked like the following:

teamname

---------------

Blue Jackets

Gold Dragons

Green Hornets

Purple Pilots

Red Devils

Silver Lions

Using a set operator create a query that will show those players who have not been assigned a team yet. Include in your query the first and last name of the player. Your output should look like the following:

first_name last_name

--------------- -------------------------

Jacob Gregory

Jeff Gregory

Using a set operator create a query that will show those teams who have won games AND were also the home team. Order your output by team name. My output looked like the following:

teamname

---------------

Blue Jackets

Gold Dragons

Green Hornets

Purple Pilots

Red Devils

Silver Lions