The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | Apr 2017 |
| Last Sign in: | 103 Weeks Ago, 3 Days Ago |
| Questions Answered: | 4870 |
| Tutorials Posted: | 4863 |
MBA IT, Mater in Science and Technology
Devry
Jul-1996 - Jul-2000
Professor
Devry University
Mar-2010 - Oct-2016
Hello, can someone please assist with the attached? Thank you in advance
Assignment 6 – Grouping DataFall 2016The due date for the assignment 6 is10/30/2016 (midnight).It must be submitted through the“Assignment 6 – Grouping Data” in Dropbox provided on the eCollege. It is important that you specifyyour name in the SQL file. The attachment name should follow the following convention:BUSA526_ASSIGNMENT6_FIRSTNAME_LASTNAME.SQLImport the assignment data codeand use the following logical schema to answer questions below. Youmustuse only one SELECT statementfor each question to get credit:1.Display the average raw score (1 point)2.Display the average raw scores of team ‘Dolphins (1 point)3.Display the average raw scores of all team (1 point)4.Which location hosted tournament on the earliest tournament date (1 point)5.Which team play in odd lane more than in even lane (1 point)6.For each game, show the bowlers who score the highest raw score (1point)
Attachments:
-----------