This is a continuation of a nasty problem I have to write a query for. The count was worked out but now need the average.
In a one table I have various attributes. The 3 in question are [admission_id] , [answer], and [mark]. The [admission_id] can have the same value in different rows. (e.g...