请问这个sparksql语句怎么改

Question

我想计算里程（mileage）小于0.1的数据个数，如下图

但是报错了，应该怎么改呢？

Answer 1

加上对mileage分组

val result3A = spark.sql("select mileage,count(mileage) as amount from cas where mileage < 0.1 group by mileage")