select
usr_id
,mch_nm
,sum(trx_amt) as trx_amt
,count(mch_nm) as trx_cnt
,min(trx_time) as first_time
from
cmb_usr_trx_rcd
where trx_amt >= 288 and usr_id = 5201314520
group by 2
order by trx_cnt desc
select
mch_nm
,sum(trx_amt) as trx_sum
,count(mch_nm) as trx_cnt
,min(trx_time) as first_time
from
cmb_usr_trx_rcd
where trx_amt >= 288 and usr_id = 5201314520
group by 1
order by trx_cnt desc
select
trx_amt
,count(trx_amt)
from cmb_usr_trx_rcd
where
mch_nm = "红玫瑰按摩保健休闲"
and year(trx_time) = 2024
and month(trx_time) between 1 and 7
group by trx_amt
limit 5;
select
date(trx_time) as trx_date
,max(trx_amt) as max_trx_amt
,min(trx_amt) as min_trx_amt
,avg(trx_amt) AS avg_trx_amt
,sum(trx_amt) as total_trx_amt
from cmb_usr_trx_rcd
where month(trx_time) = 9 and year(trx_time) = 2024 and mch_nm = "红玫瑰按摩保健休闲"
group by trx_date
order by trx_date
select
date(trx_time) as trx_date
,max(trx_amt) as max_trx_amt
,min(trx_amt) as min_trx_amt
,round(avg(trx_amt),2) AS avg_trx_amt
,sum(trx_amt) as total_trx_amt
from cmb_usr_trx_rcd
where month(trx_time) = 9 and year(trx_time) = 2024 and mch_nm = "红玫瑰按摩保健休闲"
group by trx_date
order by trx_date
select
trx_time
,max(trx_amt) as max
,min(trx_amt) as min
,round(avg(trx_amt),2) AS avg
,sum(trx_amt) as sum
from cmb_usr_trx_rcd
where month(trx_time) = 9 and year(trx_time) = 2024 and mch_nm = "红玫瑰按摩保健休闲"
group by trx_time
order by trx_time
select *
from cmb_usr_trx_rcd
where usr_id = 5201314520 and year(trx_time) = 2024 and month(trx_time) = 9 and hour(trx_time)between 1 and 5
order by trx_time
select distinct
k1.live_id
,live_nm
,count(usr_id) as con_id
from ks_live_t1 as k1
left join ks_live_t2 as k2
on k1.live_id = k2.live_id
where substring(enter_time,12,2) = "23"
group by 1,2
order by con_id desc
limit 5
select distinct
live_id
,count(usr_id) as con_id
from ks_live_t1 as k1
where substring(enter_time,12,2) = "23"
group by live_id
order by con_id desc
limit 5