public void testAvgAndAvgDistinct() { setUpAggregateTest(); DoubleProperty avg = DoubleProperty.fromFunction(Function.avg(TestModel.LUCKY_NUMBER), "avg"); DoubleProperty avgDistinct = DoubleProperty.fromFunction( Function.avgDistinct(TestModel.LUCKY_NUMBER), "avgDistinct"); SquidCursor<TestModel> cursor = database.query(TestModel.class, Query.select(avg, avgDistinct)); try { cursor.moveToFirst(); assertEquals(2.0, cursor.get(avg)); assertEquals(4.0, cursor.get(avgDistinct)); } finally { cursor.close(); } }