Question: Consider the table below, called Roster. If I wanted to determine what the average PtsPerGame value was by position ( e . g . ,

Consider the table below, called Roster. If I wanted to determine what the average PtsPerGame value was by position (e.g., how many points per game are scored on average by those listed as chasers), which of the following would need to be part of my query?
PlayerID Name Position PtsPerGame
1 Moe Chaser 14.5
2 Stampy Keeper 5.5
3 Agnes Chaser 18.2
4 Blinky Beater 9.0
5 Rainier Beater 4.8
6 Selma Seeker 15.3
7 Jimbo Chaser 16.7
Group of answer choices
A SORT BY clause
A GROUP BY clause
A SUM function
An analytical function

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!