sql command to find out how many players score how much

I have a table like these

This is a table in the database. It shows 70 countries around the world with player names and gender. It shows which player score how many goals in which year. The years goes from 1990 to 2015. So the table is large. Now I would like to know how many goals all female player and how many male player from Germany have scored from 2010 to 2015. So I would like to know the total score of german male player and the total score of german female player every year from 2010 to 2015 with a Sqlite

I expecting these output

>Solution :

SELECT 
country,
gender,
year,
sum(score) as score
from <table_name>
where country ='Germany' and year in ('2015','2014','2013','2012','2011','2010')
group by 1,2,3

• filtering on country and the years you are interested in
• then summing up total score using group by