Question: I want the solution because I have a test please I want help. The solution is in simple sql language . Only I have an
I want the solution because I have a test please I want help. The solution is in simple sql language. Only I have an hour
Given the following relational schema where primary keys are underlined and foreign keys are marked with #: COUNTRY(countryID, countryName, countryDialingCode) TEAM(teamID, teamName, countryId) PLAYER(playerID, playerFname, playerLname, playerDoB, #teamID) Game(gameID, gameName, gameLevel, year) a) Express the following queries in SQL: i. Add the column gameID of type Integer as a foreign key in table TEAM.[1.5] ii. Find the details of players whose first names start with S. [1] iii. Find the number of players in each team. [1] iv. Change the gameName of the game with id = 5 to Ping Pong. [1] v. Display the name of the country having the highest number of teams.[1.5] vi. List the details of games played by teams from Oman. [1.5] b) Create view lessThan20 that contains player last name, player ID, player country ID, game name of players who are less than 20 years old. [2.5
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
