SQL querry - I'm a beginner
From: Christian Kuschnig <curt_at_gmx.at>
Date: 29 May 2001 04:36:11 -0700
Message-ID: <420cd6db.0105290336.500cd2ad_at_posting.google.com>
Date: 29 May 2001 04:36:11 -0700
Message-ID: <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
Thanks a lot
christian
Miller 1 0 2
Mike 3 3 0
Phil 0 0 1