select
snd_usr_id
from
tx_red_pkt_rcd
where pkt_amt in ('200','520')
group by snd_usr_id
having count(*)>=5
order by snd_usr_id

select
snd_usr_id,count(*) as cnt
from
tx_red_pkt_rcd
where pkt_amt in ('200','520')
group by snd_usr_id
having cnt>=5
order by snd_usr_id

select
lpad(new.hour_time,2,'0'), new.cnt
from(
	select
	hour(enter_time) as hour_time,count(*) as cnt
from
ks_live_t1 t1
join ks_live_t2 t2 on t1.live_id = t2.live_id
group by hour_time
) as new
order by hour_time

select
*
from
listen_rcd
where
start_time between '2023-12-10 00:00:00' and '2023-12-31 23:59:59'
and song_id = '13'
order by start_time

select
 sgi.singer_id,sgi.singer_name,ai.album_id,ai.album_name,count(*) as play_count
 from
 listen_rcd lr
 left join song_info si on lr.song_id = si.song_id
 left join singer_info sgi on si.origin_singer_id = sgi.singer_id
 left join album_info ai on si.album_id = ai.album_id
group by sgi.singer_id,ai.album_id
having play_count = 0

select
dt,tmp_h,tmp_l,con
from
weather_rcd_china
where con like '%雪%' and city = 'beijing'

select
dt,tmp_h,tmp_l,con
from
weather_rcd_china
where con like '%雪%'

select
upper(singer_name) as up_singer_name
from
singer_info

select
singer_name,char_length(singer_name)
from
singer_info

select
singer_name,length(singer_name)
from
singer_info

select
 length(singer_name) as len_singer_name, count(*) as cnt_len
 from
 singer_info
 group by len_singer_name

select
replace(song_name,'人','狗') as new_song_name
from
song_info
where song_name like '%人%'

select
replace(song_name,'人','狗') as new_song_name
from
song_info

select
replace(singer_name ,' ','') as new_singer_name
from
singer_info

select
replace(singer_name ,' ','""') as new_singer_name
from
singer_info

select
cust_uid, cnt as trip_cnt, rank() over(order by cnt desc, cust_uid) as rk
from(
	select
cust_uid,count(*) as cnt
from
didi_sht_rcd
group by cust_uid
) as t
limit 10

select
cust_uid, cnt as trip_cnt, rank() over(order by cnt, cust_uid) as rk
from(
	select
cust_uid,count(*) as cnt
from
didi_sht_rcd
group by cust_uid
) as t
limit 10

select
cust_uid, cnt, rank() over(order by cnt, cust_uid) as rk
from(
	select
cust_uid,count(*) as cnt
from
didi_sht_rcd
group by cust_uid
) as t
limit 10

select mch_typ2,count(*) as trx_cnt, sum(trx_amt) as sum_trx from mt_trx_rcd group by mch_typ2 order by trx_cnt desc

select
round(avg(timestampdiff(minute,start_time,end_time)),2) as avg_time,
max(timestampdiff(minute,start_time,end_time)) as max_time,
count(*) as cnt
from
	hello_bike_riding_rcd
group by
	user_id