Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Transactions On Large Scale Data And Knowledge Centered Systems Xxxviii Special Issue On Database And Expert Systems Applications Lncs 11250

Authors: Abdelkader Hameurlain ,Roland Wagner ,Sven Hartmann ,Hui Ma

1st Edition

3662583836, 978-3662583838

More Books

Students also viewed these Databases questions

Question

Define policy making?

Answered: 1 week ago

Question

Define co-ordination?

Answered: 1 week ago

Question

What are the role of supervisors ?

Answered: 1 week ago