The query:

```
select year,sum(mark),sum(maxmark) 
from table1 
group by parameterno

```

yields an error message:

> 
> Column 'table1.year' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
> 
> 
>