Re: SQL Querry

From: Kenneth Koenraadt <plovmand_at_hotmail.com>
Date: Fri, 25 May 2001 21:36:33 GMT
Message-ID: <3b0ece39.5732340@news.mobilixnet.dk>

Hi Christian,

SELECT player, card as Cardtype, Count(*) FROM cards
GROUP BY player, card;

Regards,

Kenneth Koenraadt
Systems Consultant
plovmand@<no-spam>hotmail.com

On 25 May 2001 13:05:27 -0700, curt_at_gmx.at (Christian Kuschnig) wrote:

>Hello!
>I've got some problems with a short qerry - I hope somoone of youe could help me!!
>
>It is out from a soccer database:
>I've the relation cards(player,match,minute,card)
>player is string, match an Integer (number of match), card can have the values
>"yellow", "red" or "yellowred".
>
>I've to write a querry that has the following result:
>(player, yellow, yellowred, red) which counts the cards for every player!
>
>It would be great if you have a solution for this probelm!
>
>Thanx Christian
>
>(curt_at_gmx.at)
Received on Fri May 25 2001 - 16:36:33 CDT