PLAYER (id int(PK), fname varchar (30) ,lname varchar(30) ,

PLAYER (id int(PK), fname varchar (30) ,lname varchar(30) ,age int ,position varchar(30) clubid int(FK), clubid is a FK to the PK of the table CLUB. (id, first name, last name,age, position in the id of the club it refers)CLUB( clubid(PK int ), name, titlesno,founded) id of the club, name of the club, number of titles, and year of foundation.INSERT 4 RECORDS FOR PLAYER AND 3 RECORDS FOR CLUB (YOU CHOOSE)Build and run the following queries:Select all the club names that has an average age of players lower than 25 playing in itSelect the first name and last name of those players younger than average.select club names with less than 3 playersReturn first name, last name age and club name of those players elder than 35Modify the table player by adding a column ‘SALARY’ int (NOT optional) and insert the salary of every player . You choose the salaries.Delete all the players older than 50 years old.Create a view that return the names and the year of foundation of those clubs that are more than 100 years old.

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.