database system 6
- 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 it
- Select the first name and last name of those players younger than average.
- select club names with less than 3 players
- Return first name, last name age and club name of those players elder than 35
- Modify 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.
#write essay #research paper #blog writing #article writing #academic writer #reflective paper #essay pro #types of essays #write my essay #reflective essay #paper writer #essay writing service #essay writer free #essay helper #write my paper #assignment writer #write my essay for me #write an essay for me #uk essay #thesis writer #dissertation writing services #writing a research paper #academic essay #dissertation help #easy essay #do my essay #paper writing service #buy essay #essay writing help #essay service #dissertation writing #online essay writer #write my paper for me #types of essay writing #essay writing website #write my essay for free #reflective report #type my essay #thesis writing services #write paper for me #research paper writing service #essay paper #professional essay writers #write my essay online #essay help online #write my research paper #dissertation writing help #websites that write papers for you for free #write my essay for me cheap #pay someone to write my paper #pay someone to write my research paper
#Essaywriting #Academicwriting #Assignmenthelp #Nursingassignment #Nursinghomework #Psychologyassignment #Physicsassignment #Philosophyassignment #Religionassignment #History #Writing #writingtips #Students #universityassignment #onlinewriting #savvyessaywriters #onlineprowriters #assignmentcollection #excelsiorwriters #writinghub #study #exclusivewritings #myassignmentgeek #expertwriters #art #transcription #grammer #college #highschool #StudentsHelpingStudents #studentshirt #StudentShoe #StudentShoes #studentshoponline #studentshopping #studentshouse #StudentShoutout #studentshowcase2017 #StudentsHub #studentsieuczy #StudentsIn #studentsinberlin #studentsinbusiness #StudentsInDubai #studentsininternational
