sql-我写的或者其他人写的

1.更新数据，补上分工

UPDATE smartoperator RIGHT JOIN smartoperation ON smartoperation.ID=smartoperator.OperationID

-- 表smartposition
where PositionID is null

-- 表smartuser
 ::"  ::" 

2.两种方法查看渠道分销顾客消费实缴

SELECT sum(cash+card) as "交钱即返的消费",sum(cash+card+Deposit) as "消费即返的消费",sum(Cash),sum(card),sum(deposit),sum(Coupon) FROM `smartcashier`

JOIN smartdistributioncustomer on smartcashier.CustomerID=smartdistributioncustomer.CustomerID

 ::"  ::"

SELECT sum(commission) as "顾客消费实缴" FROM `smartdistributioncommission`
 ::"  ::" AND
type 

3.两种写法查看升级花费（第二种是开发写的）

SELECT sum(commission) as "升级花费",sum(amount) as "升级佣金" from smartdistributioncommission
 ::"  ::" 

SELECT
    date_format(CreateTime, '%Y-%m-%d') AS CreateTime,
    Commission
FROM
    smartdistributioncommission
WHERE

AND CreateTime >= '2019-02-28'
AND CreateTime < '2019-03-01'

ORDER BY
    CreateTime ASC

---

-- 结果：查看最新的5个收费项目的信息
SELECT * FROM
(
SELECT charge.ID,charge.Name,charge.Remark,charge.IsDeal,charge.Mode,charge.PinYin,charge.Size,charge.Code,charge.PrintName,charge.ProductAdd,charge.ProductType,

    CASE
        WHEN rc.Price IS NOT NULL
            THEN rc.Price
        ELSE charge.Price END
    AS Price,

    CASE
        WHEN rc.`Status` IS NOT NULL
            THEN rc.`Status`
        WHEN product.RetailStatus IS NOT NULL
            THEN product.RetailStatus
         AND rc2.`Status` IS NOT NULL
            THEN rc2.`Status`
        ELSE charge.`Status` END
    AS Status,

    unit.Name AS UnitName, category.Name AS CategoryName

FROM SmartCharge AS charge

    LEFT JOIN SmartProduct AS product ON charge.ID = product.ChargeID
    INNER JOIN SmartUnit AS unit ON charge.UnitID = unit.ID
    INNER JOIN SmartChargeCategory AS category ON charge.CategoryID = category.ID

)
AS result

 ) )

ORDER BY result.Status DESC,result.ID DESC
LIMIT ,