問答題
1）根據(jù)表查詢平均成績大于等于 60 分的同學的學生編號和學生姓名和平均成績 2）根據(jù)表查詢在 SC 表存在成績的學生信息 實驗數(shù)據(jù)： 學生表： 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" , "孫風" , "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" , "女") 成績表 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" , "語文" , "02"); insert into Course values ("02" , "數(shù)學" , "01"); insert into Course values ("03" , "英語" , "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" , "王五")
