Excel operation: 1: need according to the driver number, how many drivers day order quantity
2: according to the quantity of single layered driver again, how many 1 single driver, how many single driver 2 * * * *
SQL questions: 1: according to the number identified the corresponding orders drivers, but can't classify according to order 1-50 points, how many people is 1 sheet, how many single 2, the driver model order
2: if you can according to the talent for 1 single - 50 single order number, you'd better the driver
CodePudding user response:
Select the driver orders, count (*) as the number of the from(select sijibianhao, count (*) as the driver order
The from sijifenceng
A group by sijibianhao)
Group by the driver order
The order by the number of
Combined a layer, the result is corresponding driver number orders