写出对应的sql语句(写出对应的sql语句是什么)
写出对应的SQL语句
1、
SELECT?*?FROM?评教表S?WHERE?SSCORE''?ANd?SSCORE?IS?NOT?NULL
2、
SELECT?AVG(SSCORE)?AS?'平均评教分数'?FROM?评教表S?WHERE?TNO='071003'
3、
SELECT?TOP?3?CNO,?AVG(SSCORE)?AS?'平均评教分数'?FROM?评教表S?GROUP?BY?CNO?ORDER?BY?AVG(SSCORE)?DESC
4、
SELECT?TNO,?CNO,?COUNT(SSCORE)?AS?'授课数'?FROM?评教表S?GROUP?BY?TNO,?CNO
5、
SELECT?TNO,?AVG(SSCORE)?AS?'平均评教分数'
FROM?评教表S
GROUP?BY?TNO
HAVING?AVG(SSCORE)(SELECT?AVG(SSCORE)?AS?'平均评教分数'?FROM?评教表S?WHERE?TNO='071003')
写出对应的 SQL语句
1,USE master
GO
CREATE DATABASE Student
ON
( NAME = Student_dat,
FILENAME = 'c:\program files\microsoft sql server\mssql\data\Student.mdf',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 5 )
LOG ON
( NAME = 'Student_log',
FILENAME = 'c:\program files\microsoft sql server\mssql\data\Student.ldf',
SIZE = 5MB,
MAXSIZE = 25MB,
FILEGROWTH = 5MB )2 use studentgocreate TABLE Student
(s_id varchar(20) not null primary key,s_name varchar(10) null,s_age int null,s_sex int null default(0) CHECK (s_sex = 0 and s_sex =1),--0代表男 1 代表女
s_Kind varchar(50) null)3. select s_name ,case s_sex when 0 then '男' else '女' end as sex from student where s_Kind ='IS' OR s_Kind ='CS'
SQL题 根据题目要求写出对应的SQL语句
--1、出版过计算机类图书的出版社编号（去掉重复行）
select?distinct?CNO?from?B
where?TCATEGORY='计算机'
--2、南开大学出版社出版的“经济”类或“数学”类图书的信息
select?*?from?B
where?TCATEGORY?in('经济','数学')?and?CNO?in?(select?CNO?from?C?where?CNAME='南开大学出版社')
--3、编号“00001”的出版社出版图书的平均价格
select?avg(TPRICE)?from?B?
where?CNO='00001'?
--4、至少出版过20套图书的出版社编号、出版社名称、出版图书套数?按出版社编号升序排列
select?B.CNO,CNAME,count(B.CNO)as?[出版图书套数]from?B?,C
where?B.CNO=C.CNO
group?by?B.CNO,CNAME
having?count(*)=20
--5、比编号“00001”出版图书套数多的出版社编号
select?CNO?from?B?
group?by?CNO?
having?count(*)(select?count(*)?from?B?where?CNO='00001')