Using a Subquery, create a query that will show the first and last name of coaches who are coaching the Red Devils team. My output looked like the following:

first_name last_name phone

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

Larry Ngao 586-355-8882

Midori Nagayama 586-852-5764

Using a Subquery create a query that will show the first and last name and team name of those players who have not had their physical yet. HINT: remember to build your subquery first. This will show those players who have had a physical. Use the outer query to show those players who are not in this group. Order your output by team name. Your output should look like the following:

first_name last_name teamname

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

Christopher Biri Blue Jackets

Barry Urguhart Gold Dragons

Frank Menchu Gold Dragons

David Lefbowitz Green Hornets

Chase Cook Green Hornets

Matt Urguhart Purple Pilots

Michael Lefbowitz Red Devils

Jason Cook Red Devils

Jack Lancer Silver Lions