select usr_id,mch_nm,sum(trx_amt) as trx_amt,count(mch_nm) as trx_cmt, min(trx_time) as first_time
from cmb_usr_trx_rcd
where usr_id = '5201314520' and trx_amt >= 288
group by mch_nm
order by trx_cmt desc
select usr_id,mch_nm,count(mch_nm) as trx_cmt,sum(trx_amt) as trx_amt, min(trx_time) as first_time
from cmb_usr_trx_rcd
where usr_id = '5201314520' and trx_amt >= 288
group by mch_nm
order by trx_cmt desc
select trx_amt, count(trx_amt) total_trx_cnt, count(distinct usr_id) unique_usr_cnt
,count(trx_amt)/count(distinct usr_id) avg_trx_per_user
from cmb_usr_trx_rcd
where left(trx_time,7) between '2023-01' and '2024-06'
and mch_nm = '红玫瑰按摩保健休闲'
group by trx_amt
order by avg_trx_per_user desc
limit 5
select trx_amt, count(trx_amt) total_trx_cnt, count(distinct usr_id) unique_usr_cnt
,sum(trx_amt)/sum(distinct usr_id) avg_trx_per_user
from cmb_usr_trx_rcd
where left(trx_time,7) between '2023-01' and '2024-06'
and mch_nm = '红玫瑰按摩保健休闲'
group by trx_amt
order by avg_trx_per_user desc
limit 5
select trx_amt, sum(trx_amt) total_trx_cnt, sum(distinct usr_id) unique_usr_cnt
,sum(trx_amt)/sum(distinct usr_id) avg_trx_per_user
from cmb_usr_trx_rcd
where left(trx_time,7) between '2023-01' and '2024-06'
and mch_nm = '红玫瑰按摩保健休闲'
group by trx_amt
order by avg_trx_per_user desc
limit 5
select trx_amt, sum(trx_amt) total_trx_cnt, sum(distinct usr_id) unique_usr_cnt
,sum(trx_amt)/sum(distinct usr_id) avg_trx_per_user
from cmb_usr_trx_rcd
where left(trx_time,7) between '2023-01' and '2024-06'
group by trx_amt
order by avg_trx_per_user desc
limit 5
select
trx_amt,
count(1) as trx_cnt
from
cmb_usr_trx_rcd
where
mch_nm = '红玫瑰按摩保健休闲'
and year(trx_time) = 2024
and month(trx_time) in (1, 2, 3, 4, 5, 6, 7)
group by
trx_amt
order by
trx_cnt desc
limit 5;
select date(trx_time) trx_date, max(trx_amt) max_trx_amt, min(trx_amt) min_trx_amt, avg(trx_amt) avg_trx_amt, sum(trx_amt) total_trx_amt
from cmb_usr_trx_rcd
where year(trx_time) = 2024 and month(trx_time) = 9
and mch_nm = '红玫瑰按摩保健休闲'
group by date(trx_time)
order by date(trx_time)
select mch_nm, sum(trx_amt) sum_trx_amt
from cmb_usr_trx_rcd
where
year(trx_time) = 2024
and usr_id = '5201314520'
group by mch_nm
order bysum(trx_amt) desc
select * from cmb_usr_trx_rcd
where usr_id = '5201314520'
and date(trx_time) between '20240901' and '20240930'
and (hour(trx_time) between 22 and 24 or hour(trx_time) between 0 and 5)
order by trx_time
select * from cmb_usr_trx_rcd
where usr_id = '5201314520'
and date(trx_time) between '20240901' and '20240930'
and hour(trx_time) between 1 and 5
order by trx_time
select * from cmb_usr_trx_rcd
where usr_id = '5201314520'
and date(trx_time) between '20240901' and '20240930'
and hour(trx_time) between 1 and 6
order by trx_time