1,case when的用法:https://www.cnblogs.com/shaopang/p/6903985.html
2,group by的用法:http://www.w3school.com.cn/sql/sql_groupby.asp
3.count()函数的用法:http://www.w3school.com.cn/sql/sql_func_count.asp
select count(*) as number from VehBasicInfo;
4,having的用法:http://www.w3school.com.cn/sql/sql_having.asp
具体的看w3school