Is it possible to create a sum/avg query on a row instead of a column?
I have a table where records store test data per studentID, for example:
------------------------------------
field1 | field2 |field3 | field4 | field5
-----|-------|------|------|-------
id5 | 80 | 60 | null | 70
------------------------------------
can I create a query that calculates the avg of all test results for this student id, and if yes, how do I ignore null values?
Is this possible or the design is flawed???
Thanks.
I have a table where records store test data per studentID, for example:
------------------------------------
field1 | field2 |field3 | field4 | field5
-----|-------|------|------|-------
id5 | 80 | 60 | null | 70
------------------------------------
can I create a query that calculates the avg of all test results for this student id, and if yes, how do I ignore null values?
Is this possible or the design is flawed???
Thanks.