select a.mch_nm as asshole_tried,a.trx_cnt as asshole_tried_cnt,b.mch_nm as darling_tried
from (
select distinct mch_nm,count(1) as trx_cnt
from cmb_usr_trx_rcd
where year(trx_time) in ('2023','2024')
and usr_id='5201314520'
group by mch_nm
having count(mch_nm)>=20
)a
left join
(
select distinct mch_nm
from cmb_usr_trx_rcd
where year(trx_time) in ('2023','2024')
and usr_id='5211314521'
)b
on a.mch_nm=b.mch_nm
order by 2 desc
select a.mch_nm as asshole_tried,a.trx_cnt as asshole_tried_cnt,b.mch_nm as darling_tried
from (
select distinct mch_nm,count(1) as trx_cnt
from cmb_usr_trx_rcd
where year(trx_time) in ('202','2024')
and usr_id='5201314520'
group by mch_nm
having count(mch_nm)>=20
)a
left join
(
select distinct mch_nm
from cmb_usr_trx_rcd
where year(trx_time) in ('202','2024')
and usr_id='5211314521'
)b
on a.mch_nm=b.mch_nm
order by 2 desc
select a.mch_nm as asshole_tried,a.trx_cnt,b.mch_nm as darling_tried
from (
select distinct mch_nm,count(1) as trx_cnt
from cmb_usr_trx_rcd
where year(trx_time) in ('202','2024')
and usr_id='5201314520'
group by mch_nm
having count(mch_nm)>=20
)a
left join
(
select distinct mch_nm
from cmb_usr_trx_rcd
where year(trx_time) in ('202','2024')
and usr_id='5211314521'
)b
on a.mch_nm=b.mch_nm
order by 2 desc
selecta.*
from(
select distinct mch_nm
from cmb_usr_trx_rcd
where
usr_id='5211314521'
and year(trx_time)='2024'
)a
inner join
(
select distinct mch_nm
from cmb_usr_trx_rcd
where
usr_id='5201314520'
and year(trx_time)='2024'
)b
on a.mch_nm=b.mch_nm
order by 1 desc
selecta.*
from(
select distinct mch_nm
from cmb_usr_trx_rcd
where
usr_id='5211314521'
and year(trx_time)='2024'
)a
inner join
(
select distinct mch_nm
from cmb_usr_trx_rcd
where
usr_id='5201314521'
and year(trx_time)='2024'
)b
on a.mch_nm=b.mch_nm
order by 1 desc
selecta.*
from(
select distinct mch_nm
from cmb_usr_trx_rcd
where
usr_id='5201314520'
and year(trx_time)='2024'
)a
inner join
(
select distinct mch_nm
from cmb_usr_trx_rcd
where
usr_id='5201314521'
and year(trx_time)='2024'
)b
on a.mch_nm=b.mch_nm
order by 1 desc
selecta.*
from(
select distinct mch_nm
from cmb_usr_trx_rcd
where
usr_id='5201314520'
and year(trx_time)='2024'
)a
inner join
(
select distinct mch_nm
from cmb_usr_trx_rcd
where
usr_id='5201314521'
and year(trx_time)='2024'
)b
on a.mch_nm!=b.mch_nm
order by 1 desc
select usr_id,
mch_nm,
trx_time,
trx_amt
from cmb_usr_trx_rcd
where trx_amt=(
select max(trx_amt)
from cmb_usr_trx_rcd
where
year(trx_time)='2024' and
usr_id='5201314520'
)
and usr_id='5201314520'
and year(trx_time)='2024'
select usr_id,
mch_nm,
sum(trx_amt) as trx_amt,
count(1) as trx_cnt,
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 4 desc
select usr_id,
mch_nm,
sum(trx_amt) as trx_amt,
count(1) as trx_cnt,
min(trx_time) as first_time
from cmb_usr_trx_rcd
where usr_id='5201314520'
and trx_amt>=288
group by
usr_id,mch_nm
order by 4 desc
select usr_id,
mch_nm,
sum(trx_amt) as trx_amt,
count(1) as trx_cnt,
min(trx_time) as first_time
from cmb_usr_trx_rcd
where usr_id='5201314520'
and trx_amt>288
group by
usr_id,mch_nm
order by 4 desc
select usr_id,
mch_nm,
sum(trx_amt) trx_amt,
count(usr_id) as trx_cnt,
min(trx_time) first_time
from cmb_usr_trx_rcd
where usr_id='5201314520'
and trx_amt>288
group by
usr_id,mch_nm
order by 4 desc
select usr_id,
mch_nm,
sum(trx_amt) trx_amt,
count(mch_nm) as trx_cnt,
min(trx_time) first_time
from cmb_usr_trx_rcd
where usr_id='5201314520'
and trx_amt>288
group by
usr_id,mch_nm
order by 4 desc
select usr_id,
mch_nm,
sum(trx_amt),
count(mch_nm) as trx_cnt,
min(trx_time) first_time
from cmb_usr_trx_rcd
where usr_id='5201314520'
and trx_amt>288
group by
usr_id,mch_nm
order by 4 desc
select usr_id,
mch_nm,
sum(trx_amt),
count(trx_amt) as trx_cnt,
min(trx_time) first_time
from cmb_usr_trx_rcd
where usr_id='5201314520'
and trx_amt>288
group by
usr_id,mch_nm
order by 4 desc
select usr_id,
mch_nm,
sum(trx_amt),
count(trx_amt) as 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 4 desc
select usr_id,
mch_nm,
sum(trx_amt),
count(trx_amt) as 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 first_time desc
select usr_id,
mch_nm,
sum(trx_amt),
count(trx_amt),
min(trx_time) first_time
from cmb_usr_trx_rcd
where usr_id='5201314520'
and trx_amt>200
group by
mch_nm