Re: SQL querry - I'm a beginner

Easy solution:

Rather than posting these annoyances to newsgroups, try using Microsoft Excel 95 or even Lotus 123 to find your answers!!!!!

or maybe use your ABACUS !!!

or contact your TUTOR !!

NB: Use brains, read books and LEARNS !

--
Erwin Susanto
Circle Global Networks
9 Raffles Place
#09-03 Republic Plaza
Singapore

e-mail: erwin_at_circleglobalnetworks.com

"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