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.