笔试题1

最新推荐文章于 2024-10-01 18:51:18 发布

zazazazaza98

最新推荐文章于 2024-10-01 18:51:18 发布

阅读量135

点赞数

分类专栏： java面试题文章标签： java

本文链接：https://blog.csdn.net/zazazazaza96/article/details/106343770

版权

java面试题专栏收录该内容

2 篇文章 0 订阅

订阅专栏

在这里插入图片描述
看这里

请写出对应的SQL语句

（1）
select 
    'range(10-20)' as age_range,gender,count(s.name) as num 
from 
    student s 
where 
    age between 10 and 20 
group by 
    gender
union all
select 
    'range(20-30)',gender,count(s.name) as num 
from 
    student s 
where 
    age between 20 and 30 
group by
    gender;
（2）
	select 
		case  
		when age>=10 and age<=20 then 'range(10-20)'
	when age>=20 and age<=30 then 'range(20-30)'
	else 'qita'
    end
		as age_range,
        gender,
       count(*) num 
    from 
      student
    group by 
       age_range ,
       gender;