Assignment 7 – Filtering Grouping Data Summer I 2017 The due date for the assignment 7 is 6/25/2017 (midnight). It must be submitted through the “Assignment 7 – Filtering Grouping Data” in Dropbox provided on the eCollege. It is important that you specify your name in the SQL file. The attachment name should follow the following convention: BUSA526_ASSIGNMENT7_FIRSTNAME_LASTNAME.SQL Import the assignment data code and use the following logical schema to answer questions below. You must use only one SELECT statement for each question to get credit. Note that you won’t get any credits if you use codes that haven’t learned in or before Topic 8 – Filtering Grouping Data: 1. Display date and location of tournaments which have total numbers of matches greater than 5 (1 point) 2. Display date, location, and number of matches of each tournament which starts in ‘Imperial Lanes’ or ‘Bolero Lanes’ (1 point). 3. Display name, and highest raw scores of bowlers who have highest raw scores greater than 150 (1 point) 4. Display the first name, last name, and average raw scores of ‘Dolphins’ team members who has average raw scores greater than 150 (1 point) 5. Display the first name, last name, and average raw scores of ‘Dolphins’ team members who has average raw scores greater than average raw scores of all bowlers (1 point) 6. List the bowlers whose highest raw scores are at least 30 points higher than their current average (1 point) 7. Show the team played either in odd lane or even lane. Note: You must use UNION to get credit (1 point) 8. Find the winning team name for each match (Note: the winning team is the team won 2 games for each match) (1 point) 9. Display information of bowlers who have average of raw scores greater than average raw scores of their captains (1 point). 10. Show the MVP bowlers’ first name, MVP bowlers’ last name, MVP bowlers’ team name, and match ID for each match. MVP bowlers are the ones scored highest raw score of each match in the winning team (Note: the winning team is the team won 2 games for each match) (1 point) The following criteria will be used to grade the assignment:  Codes are run with detail comment, accurate, and answers are correct. ***************************NOTE ************************************* Please feel free to consult your instructor by email or phone, if you have questions or need assistance!!