select usr_id, min(trx_time) as first_time, mch_nm from cmb_usr_trx_rcd
where mch_nm = '红玫瑰按摩保健休闲' and usr_id = 5201314520

select mch_nm, sum(trx_amt) as sum_trx_amt from cmb_usr_trx_rcd
where usr_id = 5201314520 and year(trx_time) = '2024'
group by mch_nm
order by sum(trx_amt) desc

select mch_nm, sum(trx_amt) as sum_trx_amt from cmb_usr_trx_rcd
where usr_id = 5201314520 
group by mch_nm
order by sum(trx_amt) desc

select * from numbers_for_fun
where b*b - 4*a*c = 0 and a<>0
order by id

select * from numbers_for_fun
where a>0 and c=0

select * from numbers_for_fun
where a = 0 and 3*b+c = -8

select * from numbers_for_fun
where a * 9 - b * 8 + c = 0

select * from numbers_for_fun
where a = 0 and b < 0 and c >= 0
order by id

select * from apple_pchs_rcd
where order_channel = '官网' and payment_method = 'Apple Pay' and product_price >= 3000
order by order_id

select * from apple_pchs_rcd
where payment_method = 'Apple Pay' and product_price >= 3000
order by order_id

select * from scores
where 
	exam_date = '2024-06-30' 
	and 
(
(subject = '历史' and score >= 90) 
or (subject = '政治' and score >=90)
or (subject = '地理' and score >=90)
)
order by score desc, student_id, subject

select * from scores
where 
	exam_date = '2024-06-30' 
	and 
(subject = '历史' and score >= 90) 
or (subject = '政治' and score >=90)
or (subject = '地理' and score >=90)
order by score desc, student_id, subject

select * from scores
where exam_date = '2024-06-30' and subject = '英语' and score between 100 and 110
order by score desc

select * from students
where class_code in ('C219', 'C220', 'C221') and gender = 'f'
order by student_id

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

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

select student_id from subject_score
where chinese + math + english >= 300

select ts_code, open_price, close_price from daily_stock_prices
where trade_date = '2023-10-9' and pct_change > 1

select ts_code, trade_date, pct_change from daily_stock_prices
where trade_date = '2023-10-9' and pct_change > 1

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;