select usr_id,mch_nm,sum(trx_amt)trx_amt,count(1)trx_cnt,min(trx_time)first_time
from cmb_usr_trx_rcd
where usr_id=5201314520
and trx_amt>=288
group by mch_nm
order by trx_cnt desc
select trx_amt,count(1)total_trx_cnt,count(distinct usr_id)unique_user_cnt,count(1)/count(distinct usr_id)avg_trx_per_user
from cmb_usr_trx_rcd
where mch_nm="红玫瑰按摩保健休闲"
and date(trx_time) between "2023-01-01" and "2024-06-30"
group by trx_amt
order by avg_trx_per_user desc
limit 5
select trx_amt,count(1) trx_ant
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
order by trx_ant desc
limit 0,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)=09
and mch_nm="红玫瑰按摩保健休闲"
group by trx_date
order by trx_date asc
select * from cmb_usr_trx_rcd
where usr_id=5201314520
and date(trx_time) between '2024-09-01' and '2024-09-30'
and (time(trx_time) between '00:00:00' and '06:00:00'
or time(trx_time) between '22:00:00' and '24:00:00')
order by trx_time
select * from cmb_usr_trx_rcd
where usr_id=5201314520
and date(trx_time) between '2024-09-01' and '2024-09-30'
and (time(trx_time) between '01:00:00' and '06:00:00'
or time(trx_time) between '22:00:00' and '24:00:00')
order by trx_time
select * from cmb_usr_trx_rcd
where usr_id=5201314520
and date(trx_time) between '2024-09-01' and '2024-09-30'
and (time(trx_time) between '01:00:00' and '06:00:00'
or time(trx_time) between '22:00:00' and '24:00:00')
select *
from cmb_usr_trx_rcd
where usr_id=5201314520
and date(trx_time) between '2024-09-01' and '2024-09-30'
and time(trx_time) between'01:00:00'and '06:00:00'
order by trx_time
select *
from cmb_usr_trx_rcd
where usr_id=5201314520
and date(trx_time) between '2024-09-01' and '2024-09-30'
and time(trx_time) between' 01:00:00'and '06:00:00'
order by trx_time
select *
from cmb_usr_trx_rcd
where usr_id=5201314520
and date(trx_time) between '2024-09-01' and '2024-09-30'
and time(trx_time) between' 01:00:00'and '06:00:00'