I am trying to average a column:
SELECT AVG(RISKRATING) AS EXPR1
WHERE (REVIEWID = '12345-04-07') AND (RISKLIKELIHOOD <> 0) AND (RISKIMPACT <> 0)
I get the error: <unable to read data>
There are simply 9 rows with these values:
how can I get the average of this column without this error?