好久沒寫SQL,寫了一下，然后讓開發(fā)在線上跑了一下數(shù)據(jù)，開發(fā)說你這個不需要子查詢就可以搞定，本來想裝逼一下佩憾，被啪啪打臉
SELECT
tab.a AS 客戶名稱,
FROM_UNIXTIME(MAX(tab.d) / 1000, '%Y-%m-%d') AS 最近下單時間,
COUNT(tab.a) AS 最近三月成交次數(shù),
AVG(tab.c) AS 最近三月平均成交金額
FROM
(SELECT
z.delivery_name a,
f.receive_total_price-f.pay_total_price c,
z.create_time d
FROM
jy_order_customer z JOIN jy_order_v2 f ON z.order_code = f.order_code
WHERE z.create_time > UNIX_TIMESTAMP('2019-05-27 00:00:00')*1000
AND z.delivery_name NOT LIKE ("%鋼銀%")
AND z.STATUS = 80
AND f.transit_type IN (0,2)) AS tab
GROUP BY a
ORDER BY COUNT(tab.a) DESC;
接下來有時間把分析過程寫一遍
