國(guó)家開放大學(xué)(數(shù)據(jù)庫(kù)基礎(chǔ)與應(yīng)用)問(wèn)答題每日一練(2019.12.27)

DECLARE @MyNO CHAR(8)
SET @MyNO="20030001"
IF (SELECT專業(yè) FROM Students WHERE 學(xué)號(hào)=@MyNO)="計(jì)算機(jī)軟件"
BEGIN
SELECT AVG(成績(jī)) AS 平均成績(jī)
FROM Score
WHERE學(xué)號(hào)=@MyNO
END
ELSE
PRINT "學(xué)號(hào)為" +@MyNO+"的學(xué)生不存在或不屬于軟件專業(yè)"
GO