how to count group maked by group by clause?

#1

I have a table called goals structured as follow:
id (PK)
player_id (FK)
match_id (FK)

For a given player_id, i want to know how many goals has scored (every
row is a goal) and how may matches have played (every group of
match_id is a match played). How to do that?

#2

On 2011-05-17 17:16, Mariano C. wrote:

Quote:

I have a table called goals structured as follow:
id (PK)
player_id (FK)
match_id (FK)

For a given player_id, i want to know how many goals has scored (every
row is a goal) and how may matches have played (every group of
match_id is a match played). How to do that?

select player_id,
count(1) as nr_goals,
count(distinct match_id) as nr_matches
from goals
group by player_id;

/Lelle

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

how to count group maked by group by clause?

comp.databases.mysql comp.databases.mysql

how to count group maked by group by clause? - 05-17-2011 , 10:16 AM

Re: how to count group maked by group by clause? - 05-17-2011 , 12:07 PM