2025-08-11
替换空格
select replace(singer_name," ","") as new_singer_name
from singer_info
2025-08-11
替换空格
select replace(singer_name," ","") as new_singer_name
from singer_info
where singer_name like "% %"
2025-08-11
美狗计
select
replace(song_name,"人","狗") as new_song_name
from song_info
where song_name like '%人%';
2025-08-11
名字中字母e左起小于等于3位的歌手
select
singer_name
, case when locate('e', singer_name) in(1,2,3) then 1 else 0 end as if_e_lessthan3
from singer_info
2025-08-11
按歌手名字字符长度统计歌手个数
select length(singer_name),
count(singer_id)
from singer_info
group by length(singer_name)
2025-08-11
统计字符长度
select singer_name,
char_length(singer_name) as len
from singer_info;
2025-08-11
歌手名字大写
select upper(singer_name) as uppered_name
from singer_info
2025-08-11
北京有雪的日子
select dt,tmp_h,tmp_l,con
from weather_rcd_china
where con like "%雪%" and city="beijing"
2025-08-11
不经过第二象限的一元一次函数
select
*
from
numbers_for_fun
where
a=0 and b>0 and c<=0
order by id
2025-08-11
不经过第三象限的一元一次函数
select
*
from
numbers_for_fun
where
a=0 and b<0 and c>=0
order by id
2025-08-11
找出与y=x有交点的所有一元一次函数
select
*
from
numbers_for_fun
where
a=0 and b!=1 and b!=0
order by id
2025-08-11
找出与X轴交点小于等于0的一元一次函数
select
*
from
numbers_for_fun
where
a=0 and b<>0 and b*c>=0
order by
id
2025-08-11
找出与X轴交点大于0的一元一次函数
select
*
from
numbers_for_fun
where
a=0 and b<>0 and b*c<0
order by
id
2025-08-11
找出所有经过原点的一元一次函数
select * from numbers_for_fun
where a=0 and b!=0 and c=0
order by id;
2025-08-11
找出所有一元一次函数
select * from
numbers_for_fun
where a=0 and b!=0
order by id;
2025-08-11
特定渠道的中档单价用户
select * from apple_pchs_rcd
where order_channel="官网" and payment_method="Apple Pay" and product_price>=3000
order by order_id;
2025-08-11
文科潜力股
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;
2025-08-11
文科潜力股
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;
2025-08-11
给英语成绩中上水平的学生拔尖
select * from scores
where exam_date="2024-06-30" and subject="英语" and score between 100 and 110;
2025-08-11
找出三个班级的女生
select * from students
where gender !="m" and class_code in("C219","C220","C221")
order by student_id;