Try this
SELECT
id,
value = sum(value)
FROM [table]
GROUP BY id
What they were testing you on was your understanding of
Aggregation
in SQL.
The are lots of aggregation methods in SQL.
Avg, Sum, Max, Min
and more.
You can generally tell if a query has an aggregation in it by the use of the
GROUP BY
clause. The following is an article which introduces you to this clause.
http://www.w3schools.com/sql/sql_groupby.asp[
^]