Re: SQL querry - I'm a beginner

are you asking us to do your homework!!!!!!!!!

"Christian Kuschnig" <curt_at_gmx.at> wrote in message news:420cd6db.0105290336.500cd2ad_at_posting.google.com...
> I'm a beginner in SQL and that' why I hope, that someone outthere could
 help me!!!
>
> The relation I've given is out of a soccer database an it's the following:
>
> cards(player, match, time, Karte)
>
> player is the name of the player (string)
> match is the number of the match (integer)
> time is that time, when a player gets a card (integer)
> card can have the values 'yellow', 'red', 'yellored'
>
> I've to write a querry that gives the result:
>
> (player, yellow, yellowred, red)
>
> which counts the number of the cards for each player!
>
> for example
>
> player yellow yellowred red
>
> Miller 1 0 2
> Mike 3 3 0
> Phil 0 0 1
>
>
> Thanks a lot
>
> christian
Received on Wed May 30 2001 - 00:58:53 CEST