不用join on ,咱这正常来说也行呀——select mch_nm from cmb_usr_trx_rcd where usr_id=5211314521 and mch_nm in (select distinct mch_nm from cmb_usr_trx_rcd where usr_id=5211314520) and year(trx_time)=2024;(还有就是我现在看到的题目了没有写升序降序,难道是网站的原因?)
虽然但是,一个大写的O制造的惨剧——
SELECT
CASE
WHEN trx_amt = 288 THEN '1.WithHand'
WHEN trx_amt = 388 THEN '2.WithMimi'
WHEN trx_amt = 588 THEN '3.BlowJobbie'
WHEN trx_amt = 888 THEN '4.Doi'
WHEN trx_amt = 1288 THEN '5.DoubleFly'
ELSE '6.Other'
END AS ser_typ,
COUNT(1) AS trx_cnt,
MIN(date(trx_time)) AS first_date
FROM
cmb_usr_trx_rcd
WHERE
mch_nm = '红玫瑰按摩保健休闲' and usr_id='5201314520'
group by ser_typ
ORDER BY
ser_typ
SELECT *
FROM cmb_usr_trx_rcd
WHERE date(trx_time) BETWEEN '2024-09-01' AND '2024-09-30'
AND usr_id='5201314520'
AND (time(trx_time)>= '22:00:00' or
time(trx_time) between '00:00:00' AND '05:00:00')
ORDER BY trx_time;
答案一样,怎么提交失败
select *
from hand_permutations
where
concat(card1, card2) like '%A%A%' or
concat(card1, card2) like '%A%K%' or
concat(card1, card2) like '%K%K%' or
concat(card1, card2) like '%K%A%'
order by id;
with data1 as (
select distinct
usr_id,
date(login_time) as login_date
from
user_login_log
where
datediff(current_date, date(login_time)) <= 30
),
data2 as (
select
T.usr_id,
T.login_date as T_date,
T_1.login_date as T_1_date
from
data1 as T
left join
data1 as T_1
on
T.usr_id = T_1.usr_id
and datediff(T.login_date, T_1.login_date) = -1
)
select
T_date as first_login_date,
concat(round(avg(T_1_date is not null)*100, 2), '%') as T1_retention_rate
from
data2
group by
T_date
order by
T_date;
select a.mch_nm as asshole_tried,a.trx_cnt, b.mch_nm as darling_tried from
(select mch_nm, count(1) trx_cnt
from cmb_usr_trx_rcd
where year(trx_time) in (2023,2024) and usr_id='5201314520'
group by mch_nm
having count(1) >=20)a
right 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, b.mch_nm as darling_tried from
(select mch_nm, count(1) trx_cnt
from cmb_usr_trx_rcd
where year(trx_time) in (2023,2024) and usr_id='5201314520'
group by mch_nm
having count(1) >=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, b.mch_nm as darling_tried from
(select mch_nm, count(1) trx_cnt
from cmb_usr_trx_rcd
where year(trx_time) in (2023,2024) and usr_id='5201314520'
group by mch_nm
having count(1) >=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 from
(select distinct mch_nmfrom cmb_usr_trx_rcd where usr_id=5211314521 and year(trx_time)=2024)a
join
(select distinct mch_nmfrom cmb_usr_trx_rcd where usr_id=5201314520 and year(trx_time)=2024)b
on a.mch_nm=b.mch_nm order by mch_nm desc
select a.mch_nm from
(select distinct mch_nmfrom cmb_usr_trx_rcd where usr_id=5211314521 and year(trx_time)=2024)a
join
(select distinct mch_nmfrom cmb_usr_trx_rcd where usr_id=5201314520 and year(trx_time)=2024)b
on a.mch_nm=b.mch_nm
select a.mch_nm from
(select distinct mch_nmfrom cmb_usr_trx_rcd where usr_id=5211314521 and year(trx_time)=2024)a
join
(select distinct mch_nmfrom cmb_usr_trx_rcd where usr_id=5201314520 and year(trx_time)=2024)b
on a.mch_nm=b.mch_nm order by mch_nm
select a.mch_nm from
(select mch_nmfrom cmb_usr_trx_rcd where usr_id=5211314521 and year(trx_time)=2024)a
join
(select mch_nmfrom cmb_usr_trx_rcd where usr_id=5201314520 and year(trx_time)=2024)b
on a.mch_nm=b.mch_nm order by mch_nm
select a.mch_nm from
(select mch_nmfrom cmb_usr_trx_rcd where usr_id=5211314521 and year(trx_time)=2024)a
join
(select mch_nmfrom cmb_usr_trx_rcd where usr_id=5201314520 and year(trx_time)=2024)b
on a.mch_nm=b.mch_nm
select distinct mch_nm from cmb_usr_trx_rcdwhere mch_nm in (select distinct mch_nm from cmb_usr_trx_rcd where usr_id=5201314520 and year(trx_time)=2024 ) and usr_id=5211314521 and year(trx_time)=2024 order by mch_nm desc
select distinct mch_nm from cmb_usr_trx_rcdwhere mch_nm in (select distinct mch_nm from cmb_usr_trx_rcd where usr_id=5201314520 and year(trx_time)=2024 ) and usr_id=5211314521 and year(trx_time)=2024
select distinct a.mch_nm from cmb_usr_trx_rcd a where mch_nm in (select distinct mch_nm from cmb_usr_trx_rcd where usr_id=5201314520 and year(trx_time)=2024 ) and usr_id=5211314521 and year(trx_time)=2024 order by a.mch_nm
select distinct a.mch_nm from cmb_usr_trx_rcd a where mch_nm in (select distinct mch_nm from cmb_usr_trx_rcd where usr_id=5201314520 and year(trx_time)=2024 ) and usr_id=5211314521 and year(trx_time)=2024
select a.mch_nm from cmb_usr_trx_rcd a where mch_nm in (select distinct mch_nm from cmb_usr_trx_rcd where usr_id=5201314520 and year(trx_time)=2024 ) and usr_id=5211314521 and year(trx_time)=2024
select a.mch_nm from
(select distinct mch_nm from cmb_usr_trx_rcd where usr_id='5201314520' and year(trx_time)=2024) a
join
(select distinct mch_nm from cmb_usr_trx_rcd where usr_id='5211314521' and year(trx_time)=2024) b
on a.mch_nm=b.mch_nm order by mch_nm desc
select b.mch_nm from
(select distinct mch_nm from cmb_usr_trx_rcd where usr_id='5201314520' and year(trx_time)=2024) a
join
(select distinct mch_nm from cmb_usr_trx_rcd where usr_id='5211314521' and year(trx_time)=2024) b
on a.mch_nm=b.mch_nm order by mch_nm desc