please look at these. if you can do these. thank you

 

1.Display name, and highest raw scores of bowlers who has highest raw scores greater than 150(1point)2.Display the Frst name, last name, and average raw scores of ‘Dolphins’ team members who hasaverage raw scores greater than 150(1 point)3.Display the Frst name, last name, and average raw scores of ‘Dolphins’ team members who hasaverage raw scores greater than average raw scores of all bowlers (1 point)4.List the bowlers whose highest raw scores are at least 20 points higher than their current average(1 point)5.Show the team played either in odd lane or even lane. Note: You must use UNION to get credit (1point)6.±ind the winning team name for each match (Note: the winning team is the team won 2 gamesfor each match) (1 point)7.Show the MVP bowlers’ Frst name, last name, team name, and match ID for each match. MVPbowlers are the one scored highest raw score of each match in the winning team (Note: thewinning team is the team won 2 games for each match) (1 point)8.List team captains who has raw score that is higher than average of other members on the team(1 point)

Attachments:

• 1494300553-Assignment 7 - Filtering Groupinng Data.docx