問(wèn)答題
1)根據(jù)表查詢平均成績(jī)大于等于 60 分的同學(xué)的學(xué)生編號(hào)和學(xué)生姓名和平均成績(jī) 2)根據(jù)表查詢?cè)?SC 表存在成績(jī)的學(xué)生信息 實(shí)驗(yàn)數(shù)據(jù): 學(xué)生表: create table Student( Sid varchar(6), Sname varchar(10), Sage datetime, Ssex varchar(10)); insert into Student values("01" , "趙雷" , "1990-01-01" , "男"); insert into Student values("02" , "錢電" , "1990-12-21" , "男"); insert into Student values("03" , "孫風(fēng)" , "1990-05-20" , "男"); insert into Student values("04" , "李云" , "1990-08-06" , "男"); insert into Student values("05" , "周梅" , "1991-12-01" , "女"); insert into Student values("06" , "吳蘭" , "1992-03-01" , "女"); insert into Student values("07" , "鄭竹" , "1989-07-01" , "女"); insert into Student values("08" , "王菊" , "1990-01-20" , "女") 成績(jī)表 create table SC( Sid varchar(10), Cid varchar(10), score decimal(18,1)); insert into SC values("01" , "01" , 80); insert into SC values("01" , "02" , 90); insert into SC values("01" , "03" , 99); insert into SC values("02" , "01" , 70); insert into SC values("02" , "02" , 60); insert into SC values("02" , "03" , 80); insert into SC values("03" , "01" , 80); insert into SC values("03" , "02" , 80); insert into SC values("03" , "03" , 80); insert into SC values("04" , "01" , 50); insert into SC values("04" , "02" , 30); insert into SC values("04" , "03" , 20); insert into SC values("05" , "01" , 76); insert into SC values("05" , "02" , 87); insert into SC values("06" , "01" , 31); insert into SC values("06" , "03" , 34); insert into SC values("07" , "02" , 89); insert into SC values("07" , "03" , 98) 課程表 create table Course( Cid varchar(10), Cname varchar(10), Tid varchar(10)); insert into Course values ("01" , "語(yǔ)文" , "02"); insert into Course values ("02" , "數(shù)學(xué)" , "01"); insert into Course values ("03" , "英語(yǔ)" , "03") 教師表 create table Teacher( Tid varchar(10), Tname varchar(10)); insert into Teacher values ("01" , "張三"); insert into Teacher values ("02" , "李四"); insert into Teacher values ("03" , "王五")