I have three tables. Player, Position and Team.

How do I write the following sql select statements

1. What is the total weekly payroll of Chicago, Dallas, Detroit and Columbus? Display the team name, team id, and total weekly payroll and the estimated total payroll of the season (assuming an 80 game season). Order the results by team name. Hint: Use the IN operator to select the teams. Display totals formatted to currency.

2. What is the total weekly payroll of the NHL and what is the estimated total payroll of the season (assuming an 80 game season)?

3. Display the number (count) of players by division and position. Only display those divisions with a count of players > 50

4. Query 8: Display all teams with a team Shot percentage > 10%. To calculate the teams shot percentage, your query should sum the goals and shots by team and calculate the shot percentage from those summed values. Display only those teams with a shot percentage > 10% in your result set. Order the data by team name. Format the percentage column to display as ###.#

5.Query 9: display players with more than 12 points sorted by Position [asc] & points [desc]

6. list all players with team_name, shiftsPerGame, Games Played (GP), Goals & Assists for a team the user selects [when prompted]. Only include players with more than 27 shifts per game and order your results in descending sequence by ShiftsPerGame. Test your query with 'DET'

DDL f or Table PLAYER CREATE TABLE "PLAYER PID" NUMBER (4,0) not null primary key PLAYER" VARCHAR2 (50 TEAM ID" VARCHAR2(3) references team POSITION ID" VARCHAR2 (3) references position GP" NUMBER(5,0) ASSISTS NUMBER(3,0) POINTS" NUMBER(3,0) GOALS NUMBER (5,0 PLUSMINUS" NUMBER(3,0 PENALTIES" NUMBER (3,0 POWERPLAY GOALS" NUMBER(3,0) SHORTHANDED" NUMBER(3,0) GAMEWINNERS" NUMBER(3,0) OTGOALS" NUMBER(3,0 SHOTS" NUMBER(4,0 SHOOTING PCT NUMBER (6,3), SHIFTSPERGAME NUMBER (6,3), FACEOFFNINPCT" NUMBER (6,3), PAYPERGAME" NUMBER (10,2 /REM INSERTING into PLAYER SET DEFINE 0FF Insert into PLAYER (PID,PLAYER, TEAM ID, POSITION ID,GP,GOALS,ASSISTS,POINTS PLUSMINUS PENALTIES,POMERPLAYGOALS,SHORTHANDED,GAMEWINNERS,OTG0ALS,SHOTS,SHOOTINGPCT,SHIFTSP Insert into PLAYER (PID,PLAYER, TEAM ID, POSITION ID, GP,G0ALS,ASSISTS, POINTS, PLUSMINUS, PENALTIES, PONERPLAYGOALS, SHORTHANDED,GAMEWINNERS,OTGOALS, SHOTS, SHOOTINGPCT, SHIFTSP Insert into PLAYER (PID,PLAYER, TEAM ID,POSITION ID, GP,G0ALS,ASSISTS,POINTS,PLUSMINUS,PENALTIES, PONERPLAYGOALS, SHORTHANDED,GAMEWINNERS,0TG0ALS,SHOTS,SHOOTINGPCT,SHIFTSP Insert into PLAYER (PID,PLAYER, TEAM ID, POSITION ID,GP,GOALS,ASSISTS,POINTS PLUSMINUS PENALTIES, POWERPLAYGOALS,SHORTHANDED,GAMEWINNERS,OTG0ALS,SHOTS,SHOOTINGPCT,SHIFTSP Insert into PLAYER (PID,PLAYER,TEAM ID, POSITION ID, GP,G0ALS,ASSISTS, POINTS, PLUSMINUS, PENALTIES,PONERPLAYGOALS, SHORTHANDED,GAMEWINNERS,OTGOALS, SHOTS, SHOOTINGPCT, SHIFTSP Insert into PLAYER PLAYER TEAM ID, POSITION ID, GP,G0ALS,ASSISTS, POINTS, PLUSMINUS, PENALTIES,POHERPLAYGOALS, SHORTHANDED,GAMEWINNERS,OTGOALS, SHOTS, SHOOTINGPCT, SHIFTSP t into PLAYER (PID,PLAYER,TEAM ID, POSITION ALS ASSISTS, POINTS, PLUSMINUS PENALTIES POWERPLAYGOALS,SHORTHANDED GAMEWINNERS,0TG0ALS,SHOT S, SHOOTINGPCT SHIFTSP Insert into PLAYER (PID,PLAYER, TEAM ID, POSITION ID,GP,GOALS,ASSISTS,POINTS PLUSMINUS PENALTIES, SHOOTINGPCT,SHIFTSP Insert into PLAYER PLAYER TEAM ID, POSITION ID,GP,G0ALS,ASSISTS, POINTS, PLUSMINUS, PENALTIES, PONERPLAYGOALS, SHORTHANDED,GAMEWINNERS,OTGOALS, SHOTS, SHOOTINGPCT, SHIFTSP Insert into PLAYER (PID,PLAYER,TEAM ID,POSITION ID, GP,G0ALS,ASSISTS,POINTS,PLUSMINUS,PENALTIES, PONERPLAYGOALS, SHOOTINGP Insert into PLAYER (PID,PLAYER, TEAM ID, POSITION ID,G P., GOALS,ASSISTS,POINTS PLUSMINUS PENALTIES POMERPLAYGOALS,SHORTHANDED,GAMEWINNERS,OTG0ALS,SHOTS,SHOOTINGPCT,SHIFTSP Insert into PLAYER (PID,PLAYER, TEAM ID, POSITION ALS, ASSISTS, POINTS MINUS,PENALTIE ERPLAYGOALS, SHORTHANDED GAMEWINNERS,OTGOALS,SHOTS,SHOOTINGPCT,SHIFTSP Insert into PLAYER (PID,PLAYER, TEAM ID, POSITION ID,GP,G0ALS,ASSISTS, POINTS, PLUSMINUS, PENALTIES, PONERPLAYGOALS, SHORTHANDED,GAMEWINNERS,OTGOALS, SHOTS, SHOOTINGPCT, SHIFTSP Insert into PLAYER (PID,PLAYER,TEAM ID,POSITION ID,GP,G0ALS,ASSISTS,POINTS PLUSMINUS PENALTIES, ERPLAYGOALS,SHORTHANDED,GAMEWINNERS,0TG0ALS,SH SHOOTINGPCT,SHIP TSP Insert into PLAYER (PID,PLAYER, TEAM ID, POSITION ID,GP,GOALS,ASSISTS,POINTS PLUSMINUS PENALTIES,POWERPLAYGOALS,SHORTHANDED,GAMEWINNERS,OTGOALS,SHOTS,SHOOTINGPCT,SHIFTSP Insert into PLAYER (PID,PLAYER, TEAM ID, POSITION ID,GP,G0ALS,ASSISTS, POINTS, PLUSMINUS, PENALTIES, PONERPLAYGOALS, SHORTHANDED,GAMEWINNERS,OTGOALS, SHOTS, SHOOTINGPCT, SHIFTSP Insert into PLAYER (PID,PLAYER, TEAM ID,POSITION ID, GP,G0ALS,ASSISTS, POINTS, PLUSMINUS,PENALTIES, PONERPLAYG0ALS, SHORTHANDED,GAMEWINNERS,0TG0ALS,SHOTS,SHOOTINGPCT, SHIFTSP t into PLAYER (PID,PLAYER, TEAM ID, POSITION ID,GP,GOALS,ASSISTS,POINTS PLUSMINUS PENALTIES ERPLAYGOALS,SHORTHANDED,GAMEWINNERS,0TG0ALS, SHOTS,SHOOTING PCT,SHIFTSP Insert into PLAYER PID,PLAYER,TEAM ID, POSITION ID,GP,G0ALS,ASSISTS, POINTS, PLUSMINUS, PENALTIES,PONERPLAYGOALS, SHORTHANDED,GAMEWINNERS,OTGOALS, SHOTS, SHOOTINGPCT, SHIFTSP Insert into PLAYER (PID,PLAYER, TEAM ID, POSITION ID,GP,G0ALS,ASSISTS, POINTS, PLUSMINUS, PENALTIES, PONERPLAYGOALS, SHORTHANDED,GAMEWINNERS,OTGOALS, SHOTS, SHOOTINGPCT, SHIFTSP Insert into PLAYER (PID,PLAYER,TEAM ID,POSITION ID,GP.G0ALS,ASSISTS,POINTS PLUSMINUS PENALTIES, PONERPLAYGOALS,SHORTHANDED,GAMEWINNERS,0TG0ALS,SHOTS,SHOOTINGPCT,SHIFTSP Insert into PLAYER (PID,PLAYER, TEAM ID, POSITION ID,GP,G0ALS,ASSISTS,POINTS PLUSMINUS PENALTIES POWERPLAYGOALS,SHORTHANDED,GAMEWINNERS,OTG0ALS,SHOTS,SHOOTINGPCT,SHIFTSP Insert into PLAYER PLAYER TEAM ID, POSITION ID,GP,G0ALS,ASSISTS, POINTS, PLUSMINUS, PENALTIES, PONERPLAYGOALS, SHORTHANDED,GAMEWINNERS,OTGOALS, SHOTS, SHOOTINGPCT, SHIFTSP Insert into PLAYER PID,PLAYER ID,POSITION ID, ALS,ASSISTS, POINT PONERPLAYGOALS, SHORTHANDED,GAMEWINNERS,0TGOALS,SHOTS,SHOOTINGPCT, SHIFTSP Insert into PLAYER (PID,PLAYER, TEAM ID, POSITION ID,GP,G0ALS,ASSISTS,POINTS PLUSMINUS PENALTIES, POMERPLAYGOALS,SHORTHANDED,GAMEWINNERS,OTG0ALS,SHOTS,SHOOTINGPCT,SHIFTSP Insert into PLAYER (PID,PLAYER, TEAM ID, POSITION ID, GP,G0ALS,ASSISTS, POINTS PLUSMINUS PENALTIES,POWERPLAYGOALS,SHORTHANDED,GAMEWINNERS OTGOALS,SHOTS,SHOOTINGPCT,SHIFTSP Insert into PLAYER (PID,PLAYER,TEAM ID,POSITION ID,GP,G0ALS ASSISTS, POINTS, PLUSMI US,PENALTIES,POWERPLAYGOALS, SHORTHANDED,GAMEWI ERS,0TGOALS, SHOTS,SHOOTINGPCT.SHIFTSP