CodePudding user response:

Select the convert (int, inventory/10) as level, the count (0), avg () group by the convert (int, inventory/10)