Hi Guys

I'm a newbie in databases and SQL worl. I have a problem. I've spent 12 hours but couldn't find the solution.

Can anyone give me a sample code, or show me the right direction please?

Here is the scenario:

I will need to find out the number of goals a player has scored in year 2009, and display various information about him such as name, shirt no etc.

The only part I couldn't figure out is the bit where I have to add all the goals scored by a certain player, and display his name, position, total number of goals scored in 2009, and shirt no.

I will be grateful if anyone can help me on this, otherwise I'm going to go mad.

players
--------
shirtNo
name
position


playedMatches
---------------
matchID
date


playerPerformance
------------------
goals
minutes
booked
matchID
shirtNo