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 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
Get step-by-step solutions from verified subject matter experts
