题海让大学四年没有难题
白天模式登陆

题目详情

多选题 •求年龄大于19岁的非计算机应用专业,姓名含有"李"的男学生姓名、系和年龄.(10.0)

A. SELECT SNAME, SPEC,AGEFROM STWHERE SNAME LIKE '%李%'ANDAGE>19 AND SPEC NOT IN('计算机应用')AND SEX='男'

B. SELECT SNAME, SPEC,AGEFROM STWHERE SNAME LIKE '李%'ANDAGE>19 AND SPEC NOT IN('计算机应用')AND SEX='男'

C. SELECT SNAME, SPEC,AGEFROM STWHERE SNAME LIKE '%李%'ANDAGE>19 AND SPEC!='计算机应用'AND SEX='男'

D. SELECT SNAME, SPEC,AGEFROM STWHERE SNAME LIKE '%李%'ANDAGE>19 AND SPEC!='计算机应用'

学科：数据库技术与应用

时间：2025-05-09 00:01:19

相关题目

相关作业

题目1
单选题
各位同学注意,该题包括单选和多选.下面的所有题都采用如下表结构,请记录下面的表结构.(下面的题目中将不提供表结构了,需要提前记录) <img src="https://tihai-oss-cloud.itihey.com/img/c0b669c40d89fa89a254bd1d537f5b0c.png"> (1)求年龄大于20岁的男学生姓名、系和年龄; (10.0)
A. SELECT SNAME, SPEC, AGE FROM ST WHERE AGE&gt;20B. SELECT SNAME, SPEC, AGE FROM ST WHERE AGE&gt;20 AND SEX='男'C. SELECT SNAME, SPEC, AGE FROM ST WHERE AGE&gt;20 OR SEX='男'D. SELECT SNAME, SPEC, AGE FROM ST WHERE SEX='男'
题目2
单选题
求课程名含有&quot;数据&quot;且'刘'姓老师教授的课程号和课程名; (10.0)
A. SELECT CNO, CNAME FROM CO WHERE CNAME LIKE '%数据%'B. SELECT CNO, CNAME FROM CO WHERE CNAME LIKE '数据%' AND TEACHER LIKE '马%'C. SELECT CNO, CNAME FROM CO WHERE CNAME LIKE '%数据%'AND TEACHER LIKE '马%'D. SELECT CNO, CNAME FROM CO WHERE CNAME LIKE '%数据%'AND TEACHER LIKE '%马%'
题目3
单选题
求课程号为2学生的平均成绩,最高成绩.(10.0)
A. select cno, max(grade), avg(grade)from sc where cno='2'B. select cno, sum(grade), avg(grade)from sc where cno='2'C. select max(grade), avg(grade)from sc where cno='2'D. select cno, count(grade), avg(grade)from sc where cno='2'
题目4
多选题
求课程号为&quot;1&quot;且分数在65到85(包含边界)之间学生的学号;(10.0)
A. SELECT SNO FROM SC WHERE CNO='1' AND GRADE BETWEEN 65 AND 85B. SELECT SNO FROM SC WHERE CNO='1' AND GRADE&gt;= 65 AND GRADE&lt;=85C. SELECT SNO FROM SC WHERE CNO='1' AND GRADE&gt;= 65 OR GRADE&lt;=85;D. SELECT SNO FROM SC WHERE CNO='1'OR GRADE BETWEEN 65 AND 85
题目5
多选题
求&quot;王丹&quot;和&quot;刘&quot;姓老师上的课程号和课程名;(10.0)
A. SELECT CNO, CNAME FROM CO WHERE TEACHER='王丹' AND TEACHER='刘%'B. SELECT CNO, CNAME FROM CO WHERE TEACHER IN ('王丹')AND TEACHER like '刘%'C. SELECT CNO, CNAME FROM CO WHERE TEACHER='王丹' AND TEACHER like '刘%'D. SELECT CNO, CNAME FROM CO WHERE TEACHER like '王丹' AND TEACHER like '刘%'
题目6
多选题
&bull;求年龄大于19岁的非计算机应用专业,姓名含有&quot;李&quot;的男学生姓名、系和年龄.(10.0)
A. SELECT SNAME, SPEC,AGEFROM STWHERE SNAME LIKE '%李%'ANDAGE&gt;19 AND SPEC NOT IN('计算机应用')AND SEX='男'B. SELECT SNAME, SPEC,AGEFROM STWHERE SNAME LIKE '李%'ANDAGE&gt;19 AND SPEC NOT IN('计算机应用')AND SEX='男'C. SELECT SNAME, SPEC,AGEFROM STWHERE SNAME LIKE '%李%'ANDAGE&gt;19 AND SPEC!='计算机应用'AND SEX='男'D. SELECT SNAME, SPEC,AGEFROM STWHERE SNAME LIKE '%李%'ANDAGE&gt;19 AND SPEC!='计算机应用'
题目7
多选题
求各系中年龄大于18岁的除计算机软件专业之外的各专业人数.(10.0)
A. select spec,count(*)from ST where age&gt;18group by spec having spec!='计算机软件'B. select sno,spec,count(*)from ST where age&gt;18group by spec having spec!='计算机软件'C. select spec,count(*)from ST where age&gt;18 and spec!='计算机软件'group by specD. select spec,count(*)from ST where age&gt;18 and spec!='计算机软件'
题目8
多选题
各系中各专业的人数,并要求专业人数小于5.(10.0)
A. select sdept, count(*)from STgroup by sdept having count(*)&lt;5B. select sno,sdept,spec, count(sno)from STgroup by sdept,spec having count(sno)&lt;5C. select sdept,spec, count(*)from STgroup by sdept,spec having count(*)&lt;5D. select sdept,spec, count(sno)from STgroup by sdept,spec having count(sno)&lt;5
题目9
多选题
查询以&quot;_B&quot; 结尾的课程的详细情况. (10.0)
A. select * from co where cname like '%_B'B. select * from co where cname like '%/_B' escape '/'C. select * from co where cname like '%\_B' escape '\'D. select * from co where cname like '_/_B' escape '/'
题目10
单选题
求课程名含有&quot;数据&quot;且'刘'姓老师教授的课程号和课程名; (10.0)
A. SELECT CNO, CNAME FROM CO WHERE CNAME LIKE '%数据%'B. SELECT CNO, CNAME FROM CO WHERE CNAME LIKE '数据%' AND TEACHER LIKE '刘%'C. SELECT CNO, CNAME FROM CO WHERE CNAME LIKE '%数据%'AND TEACHER LIKE '刘%'D. SELECT CNO, CNAME FROM CO WHERE CNAME LIKE '%数据%'AND TEACHER LIKE '%刘%'
Copyright © 2022 津ICP备2021001502号