Don't know if there is any SQL statements for the average of the greater than 0

Value
8
8
0
7
5
6

Direct use AVG, will count zero inside, is there any way can eliminate 0, again calculate average

CodePudding user response:

Combined with the where xxx> 0