2026-01-14
输出特定日期上市的银行
select *
from stock_info
where list_date between '2006-06-01' and '2006-09-01' and industry='银行'
2026-01-14
A和K之间的手牌（3）
select *
from hand_permutations
where card1 between 'A' and 'K' and card2 between 'A' and 'K'
order by id asc
2026-01-14
A和K之间的手牌（2）
select *
from hand_permutations
where card1 between 'A' and 'K' or card2 between 'A' and 'K'
order by id asc
2026-01-14
A和K之间的手牌（1）
select *
from hand_permutations
where card1 between 'A' and 'K'
order by id asc
2026-01-13
交易金额在5000至10000（含边界）的所有交易
select *
from cmb_usr_trx_rcd
where trx_amt between 5000 and 10000
order by trx_amt desc
limit 5;
2026-01-13
交易金额大于10000元的所有交易
select *
from cmb_usr_trx_rcd
where trx_amt>100000
order by trx_amt desc
2026-01-13
性别已知的听歌用户
select *
from qqmusic_user_info
where (gender='f' or gender='m') and year(birth_date)=1980
order by birth_date asc
2026-01-13
21世纪上市的银行
select *
from stock_info
where list_date>='2000-01-01' and industry='银行'
order by list_date asc
2026-01-13
输出地区为北京的所有银行
select *
from stock_info
where area='北京' and industry='银行'
order by list_date asc
2026-01-13
1989年12月13日出生的女歌手
select *
from singer_info
where birth_date='1989-12-13' and gender='f'
2026-01-13
找出所有港台歌手
select *
from singer_info
where type2='港台'
2026-01-13
找出所有港台乐队
select *
from singer_info
where type2='港台' and type3='乐队'
2026-01-13
至少两门科目大于等于110分的学生
select *
from subject_score
where (chinese>=110 and math>=110) or (math>=110 and english>=110) or (chinese>=110 and english>=110)
order by student_id asc
2026-01-13
至少两门科目大于等于110分的学生
select *
from subject_score
where (chinese>110 and math>110) or (math>110 and english>110) or (chinese>110 and english>110)
order by student_id asc
2026-01-12
CASE WHEN-老中青教师数量
select case when enter_date>='2010-01-01' then '青年教师' when enter_date<'2000-01-01' then '资深教师' else '中年教师' end as teacher_type,count(*) as teacher_count
from teachers
group by teacher_type
2026-01-12
CASE WHEN-男女学生的数量
select case when gender='m' then '男' when gender='f' then '女' end as gender_text,count(*) as student_count
from students
group by gender_text
2026-01-12
聚合函数-比较两位同学的数学成绩
select student_id,max(score) as max_score,min(score) as min_score,avg(score) as avg_score
from scores
where (student_id='460093' or student_id='735011') and subject='数学'
group by student_id
2026-01-12
聚合函数-735011学生的语文成绩
select max(score) as max_score,min(score) as min_score,avg(score) as avg_score
from scores
where student_id='735011' and subject='语文'
2026-01-12
条件过滤-没有职称的老教师
select name,subject,class_code,enter_date
from teachers
where enter_date<'2010-01-01' and qualification is null
order by enter_date asc
2026-01-12
条件过滤-查找1994年至1997年毕业的女教师
select name,subject,class_code,graduate_date
from teachers
where graduate_date>='1994-01-01' and graduate_date<='1997-12-31' and gender='f'
order by graduate_date asc