统计订单表状态：未付款 已付款 待收货 。。。。等等
SELECT
FORMAT(COUNT(order_main.order_state = 1 OR NULL),0) AS 未付款, FORMAT(COUNT(order_main.order_state = 2 OR NULL),0) AS 已付款, FORMAT(COUNT(order_main.order_state = 3 OR NULL),0) AS 待收货, FORMAT(COUNT(order_main.order_state = 4 OR NULL),0) AS 待评价, FORMAT(COUNT(order_main.order_state = 5 OR NULL),0) AS 已完成, FORMAT(COUNT(order_main.order_state = 6 OR NULL),0) AS 已取消
FROM order_main
格式化浮点数 format(number, length);
三位一逗号+小数保留
length:保留几位小数
