Given the following basketball team schema could someone help me with the following

Player [ID: integer, Name: varchar(64), Birthday: date, Address: varchar(128), Email: varchar(32), PhoneNumber: char(10), Position: varchar(16)]

Manager (ID: integer, LoginID: varchar(16), Name: varchar(64), Password: varchar(8), Birthday: date, Address: varchar(128), Email: varchar(32), PhoneNumber: char(10))

ManagerCertificate (ManagerID: integer, CertificateId: integer, Certificate: blob) - Foreign key: ManagerID references Manager(ID)

Doctor (Email: varchar(32), Name: varchar(64), PhoneNumber: char(10))

TakeExam (PlayerID: integer, DocEmail: varchar(32), TestDate: date, TestResult: varchar(256))

- Foreign key: PlayerID references Player(ID)

- Foreign key: DocEmail references Doctor(Email)

Stats (PlayerID: integer, Year: char(4), TotalPoints: integer, ASPG: integer) - Foreign key: PlayerID references Player(ID)

Training (TrainingName: varchar(256), Instruction: varchar(256), TimePeriodInHour: integer)

AssignTraining (PlayerID: integer, ManagerID: integer, TrainingName: varchar(256))

- Foreign key: PlayerID references Player(ID)

- Foreign key: ManagerID references Manager(ID)

- Foreign key: TrainingName references Training(TrainingName)

Game (GameID: integer, Date: date, Result: varchar(16), PlayingVenue: varchar(256), OpponentTeam: varchar(32))

Play (PlayerID: integer, GameID: integer)

- Foreign key: PlayerID references Player(ID)

- Foreign key: GameID references Game(GameID)

1. 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.

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

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

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

4. Show emails, name of Doctors who have given exams.

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

Any help is appreciated !