Re: SQL querry - I'm a beginner
Date: Tue, 29 May 2001 22:34:33 -0500
Message-ID: <DRZQ6.82$g03.12228_at_nnrp1.sbc.net>
what i find even more annoying than cross posting are identical, separate postings to multiple newsgroups. what, did you you think that no one will notice ?
"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 - 05:34:33 CEST