value = sum(value)
GROUP BY id
What they were testing you on was your understanding of
The are lots of aggregation methods in SQL.
Avg, Sum, Max, Min
You can generally tell if a query has an aggregation in it by the use of the
clause. The following is an article which introduces you to this clause.