Question: Consider the table below, called Roster. If, in addition to determining the average PtsPerGame value by position, I only wanted to show those positions with

Consider the table below, called Roster. If, in addition to determining theConsider the table below, called Roster. If, in addition to determining the average PtsPerGame value by position, I only wanted to show those positions with a PtsPerGame average of under 12, which of the following would I need to use? (Choose the best answer.) 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

Consider the table below, called Roster. If, in addition to determining the average PtsPerGame value by position, I only wanted to show those positions with a PtsPerGame average of under 12, which of the following would I need to use? (Choose the best answer.) A HAVING clause A WHERE clause An ORDER BY clause 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!