Question: Using a set operator create a query that will show both the players and the coaches. Include in your output the first and last name

Using a set operator create a query that will show both the players and the coaches. Include in your output the first and last name of the players and coaches along with the word Player if they are a player and Coach if they are a coach. Order your output by Coaches first and then Players. Your output will have 44 rows. A partial result set is as follows:

first_name last_name Coach/Player

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

Alfred Dillinger Coach

Allen Timothy Coach

Audrey Ropeburn Coach

Bob Scott Coach

Carlos Velasquez Coach

James Barney Coach

Jim Johnson Coach

Larry Ngao Coach

Mark Quigley Coach

Martin Sam Coach

Midori Nagayama Coach

Steve Clark Coach

Theodore Turner Coach

Tim Ford Coach

Tom Jones Coach

Warren Tanner Coach

Anthoney Catchpole Player

Barry Urguhart Player

Ben Axch Player

Ben Biri Player

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

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...

Need help with this. Use SQL Developer to execute SQL commands to do the following. Assume there are over 100 employees in the table so you must create the query to return all employees that meet the...

Need sql. Need to be joins I believe 1. Using the Football database, create a query that will show the team name and gamedate for those teams that have not won a game. Remove from your output the...

How do I do these SQLs? 1. Using the Football database, create a query that will show the team name and gamedate for those teams that have not won a game. Remove from your output the team named No...

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...

Homework #4 ~ Single Table Queries 1) Create a query that will show the name of each customer and their phone number for all customers who live in Shelby township. Make sure the first and last name...

1. Log in to your Oracle ApEx account and navigate to the SQL Command window. We are going to use the Countries table. Write a query to select all columns in the COUNTRIES table. 2. Using the...

*Please help. SQL Server management studio.* Homework #4 ~ Single Table Queries Create a query that will show the name of each customer and their phone number for all customers who live in Clinton...

The case discusses the dilemma of the CFO of PSUWC Energy LLC, an energy generating firm, who needs to present his recommendation to the company Board regarding a proposed investment in a new...

Need help with this assignment.I've attached the excel workbook that should be used to record answers and the case scenario. The case discusses the dilemma of the CFO of PSUWC Energy LLC, an energy...

According to Bohrs theory, the time-averaged magnetic field at the centre (i.e. nucleus) of a hydrogen atom due to the motion of electrons in the n th orbit is proportional to (n = principal quantum...

State whether the following statement is true or false. Explain. The graph of y=-4(x-3)2-20 has no x-intercepts. Select the correct choice below and, if necessary, fill in the answer box to complete...

2 An extract from Penang Garages plc's latest statement of financial position is shown below. The garage company sells cars and repairs old vehicles. It has many competitors. Extract from Penang...

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

What was it you did in this situation that caused others to follow you?

1 what changes would you propose to both TPS and to FPS in order to cope with customer demands for increasing product variety and more rapid model changes? A car assembly plant is built around a...

6 What matters more: value to the customer or value to the shareholder? Refer to section 3.4 of Chapter 3 in formulating your response. How does this question impact on the philosophy of lean...