select trx_amt,
 count(1) AS total_trx_cnt,
 count(distinct usr_id) as unique_usr_cnt,
 count(1) / count(distinct usr_id) AS avg_trx_per_user 
from 
cmb_usr_trx_rcd 
where mch_nm = '红玫瑰按摩保健休闲'
and
(
(year(trx_time) = 2023 and month(trx_time) between 1 and 12)
or (year(trx_time) = 2024 and month(trx_time) between 1 and 6)
)
group by 
trx_amt
order by
    avg_trx_per_user desc 
limit 5

select trx_amt,
 count(1) AS total_trx_cnt,
 count(distinct usr_id) as unique_usr_cnt,
 count(1) / count(distinct usr_id) AS avg_trx_per_user 
from cmb_usr_trx_rcd 
where mch_nm = '红玫瑰按摩保健休闲'
and
(
(year(trx_time) = 2023 and month(trx_time) between 1 and 12)
or (year(trx_time) = 2024 and month(trx_time) between 1 and 6)
)
group by trx_amt

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) between 1 and 7
group by 
trx_amt
order by
trx_cnt desc
limit 5

select trx_amt,
 count(1) AS trx_cnt
from cmb_usr_trx_rcd 
where year(trx_time) = 2024
and month(trx_time) between 1 and 7
group by 
trx_amt
order by
trx_cnt desc
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 mch_nm = '红玫瑰按摩保健休闲'
and date(trx_time)between '2024-09-01' and '2024-09-30'
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,
 avg(trx_amt) as avg_trx_amt,
 sum(trx_amt) as total_trx_amt
from cmb_usr_trx_rcd 
where mch_nm = '红玫瑰按摩保健休闲'
and date(trx_time)between '2024-09-01' and '2024-09-30'
group by date(trx_time)
order by trx_date

select * from stock_info 
where list_date between '2006-06-01'and '2006-09-01'
and industry = '银行'

select * from hand_permutations 
where (card1 between 'A'and 'K') and(card2 between 'A'and 'K')
order by id

select * from hand_permutations 
where card1 between 'A' and 'K' or card2 between 'A' and 'K' 
order by id

select * from hand_permutations 
where card1 between 'A' and 'K'
order by id

select * from cmb_usr_trx_rcd 
where trx_amt between 5000 and 10000
order by trx_amt desc
limit 5

select * from cmb_usr_trx_rcd 
where trx_amt > 100000
order by trx_amt desc

select * from stock_info 
where industry = '银行' and year(list_date) > 1999
order by list_date

select * from hand_permutations 
where card1 > 'J' and card1 < 'K'
and
 card2 > 'J' and card2 < 'K'
order by id

select * from subject_score 
where chinese > 100 or math > 100 or english > 100
order by chinese

select * from qqmusic_user_info 
where (gender ='f'or gender='m')
and (year(birth_date)=1980)
order by birth_date

select * from singer_info 
where year(birth_date) < 2000 and gender = 'm'

select * from stock_info 
where area = '北京' and industry = '银行'
order by list_date

select * from singer_info 
where gender = 'f' and birth_date ='1989-12-13'

select *from singer_info 
where type2 = '港台'
order by singer_id