Question: With the following basic table layouts, write a SQL statement for the questions below: Players (PlayerID, FirstName, LastName, PositionID) Salaries (SalaryID, PlayerID, Amount) ScoredGoals (GoalId,
With the following basic table layouts, write a SQL statement for the questions below: Players (PlayerID, FirstName, LastName, PositionID) Salaries (SalaryID, PlayerID, Amount) ScoredGoals (GoalId, PlayerID, GameID, Minute) Positions (PositionID, PositionName) 1. Find the 3rd highest paid player 2. Find the 3rd lowest paid player 3. Which position scored the most goals? 4. Which players never scored? 5. Which player scored the most goals? 6. Which player scored the most goals in a single game? 7. What is the salary paid per goal per position? 8.What is the average minute of scoredgoals for each game? 9. What should the Salaries table look like if we needed to track historical data? 10. Create an application that will prompt for a user to input a string. Using the users inputted string, find the first letter that is not repeated. For example: If given the String Bubble, the letter u would be the first character returned from the program. Once the first character is found and displayed back to the user, rewrite the string in order of number of occurrences and order from the inputted string. In the above example Bubble would then be rewritten as uleBbb. Display this to the user.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
