sql question is below create table statements

Table Name: Sport

Fields Type Key

Sport_ID NUMBER Primary Key

Sport_Name TEXT -

Table Name: Donor

Fields Type Key

Donor_Id NUMBER Primary Key

Donor_Name TEXT -

Donor_Email TEXT Unique Key

Table Name: Golfer

Fields Type Key

Golfer_Id NUMBER Primary Key

Donor_Id NUMBER Foreign Key (Donor)

Sport_ID NUMBER Foreign Key (Sport)

GOLFER_NAME TEXT -

GOLFER_Email TEXT Unique Key

SHIRT_SIZE NUMBER -

Start with the script created for part 1 of the Database Design Assignment. Add the following to this script:

Insert date into each of your database tables. Be sure to insert at least 5 golfers, at least 3 teams and at least 10 donors. Also be sure to insert at least 1 donor who is sponsoring multiple golfers for different pledge amounts.

Write a query to return the total amount pledged for each sports team. Remember, the pledge amount is per hole played and the goal is to play 100 holes of golf. Show the sports team name, level, and gender. Order the results by total pledged amount from highest to lowest amount.

Write a query to return the total amount pledged for each golfer. List the golfer name, spots team that he/she is playing for, and the total amount pledged. Order the results to show the golfers with the most to the least amount pledged.

Write a query to list the sponsors for each sports team. List the team sport, team level, and team gender. List the sponsor name and total amount pledged for the team. Order the results by Team ID.

PART 1(done)

Table Name: Sport

Fields Type Key

Sport_ID NUMBER Primary Key

Sport_Name TEXT -

Table Name: Donor

Fields Type Key

Donor_Id NUMBER Primary Key

Donor_Name TEXT -

Donor_Email TEXT Unique Key

Table Name: Golfer

Fields Type Key

Golfer_Id NUMBER Primary Key

Donor_Id NUMBER Foreign Key (Donor)

Sport_ID NUMBER Foreign Key (Sport)

GOLFER_NAME TEXT -

GOLFER_Email TEXT Unique Key

SHIRT_SIZE NUMBER -

Player_Level_Id NUMBER Foreign Key (Player_Level)

Table Name: Golf_Sponsor

Fields Type Key

Golf_Sponsor_Id NUMBER Primary Key

Golfer_Id NUMBER Foreign Key (GOLFER)

Donor_Id NUMBER Foreign Key (Donor)

Price_Per_Hole NUMBER -

Play_Date Date -

Payment_Date Date -

Payment_Method_Id NUMBER Foreign Key (Payment_Method)

Table Name: Payment_Method

Fields Type Key

Payment_Method_Id NUMBER Primary Key

Payment_Method_Name TEXT Unique Key

Table Name: Player_Level

Fields Type Key

Player_Level_Id NUMBER Primary Key

Player_Level_Name TEXT Unique Key