Hello Any help would be appreciated I already have an idea of some of the queries but need help making sure i am on the right path please.

it is mySQL queries

Schema something like this just an idea

Player[id,name,age,address,email,phone,position]

Manager[id,loginID,name,password,age,address,email.phone]

ManagerCert[ManagerID,certID,certificate]

Doctor[email,name,phone]

Exams[playerID,docemail,result,dateoftest]

Playerstats[playerid, year, pointstotal, aspg]

Game[gameid,date,result,playingvenue,opponentteam]

Show the total points that player John Paul has scored each year (assume there is only one John Paul).

Select distinct name, distinct totalpoints, year

From Player, Stats

Where name = John Paul;

Show the names and emails of every manager who has exactly 3 distinct certificates.

Select name, email

From Manager

Group by ManagerCertificate

Having count(distinct certificate) > 3;

Show the names of every player who has played a game at Arrowhead Stadium and won (Result = win), in descending order of age.

Select name, birthday

From player, game

Where playingvenue ='Arrowhead Stadium' and result ='win'

Order by birthday desc;

Show emails, name of Doctors who have given exams.

Select email, name

From Doctor

Where

Find the games that players named John Paul and Mark Rober have played in, using set operators (UNION, INTERSECT, MINUS, etc...). Show the games ID, games date, venue, and result.

//Select

Perform the same query as problem 6, without using set operators (UNION, INTERSECT, MINUS, etc...)

Find the Names and IDs of players who have scored more points than the average player.

Select name, ID

From player

Where

Show all players that were born on the same day (I.E. If Bob and Joe were both born on 12/25/95, and Jim and Steve were both born on 7/4/94, show the names and the birthday they share).

Find the total number of points the Aggie basketball team scored in 2019.

Select ....