-- 每日单量
select DATE_FORMAT(createtime,'%Y-%m-%d') as days,count() count from ibt_shop_order group by days;
-- 每周单量
select DATE_FORMAT(createtime,'%Y-%u') as weeks,count() count from ibt_shop_order group by weeks;
-- 每月单量
select DATE_FORMAT(createtime,'%Y-%m') as months,count() count from ibt_shop_order group by months;
SELECT FROM jsc_order_refund where refund_status = 0 and refund_money > 1
-- 每季度
SELECT click_date as q,IFNULL(b.con,0) as c FROM(SELECT 1 as click_date UNION ALL
SELECT 2 as click_date UNION ALL
SELECT 3 as click_date UNION ALL
SELECT 4 as click_date) a LEFT JOIN(
SELECT QUARTER(from_unixtime(create_time,'%Y%m%d')) as mon, COUNT(*) as con FROM gwc_enter_orders GROUP BY QUARTER(from_unixtime(create_time,'%Y%m%d')))
b ON click_date=b.mon
发表评论: