Hi i am using OrientDB version 2.0.8 and as far as i can see the AVG() method only returns the integer part of the result and discards the decimal part.
Would be helpful if it supports an optional param:
Select AVG(rating, true) from Ratings will return the decimal part as well.
Regards
Sandeep