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.