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

select month(入學(xué)日期) as 入學(xué)月份,count(*) as 人數(shù)
from students
group by month(入學(xué)日期)

create procedure xxk5
(
@a char(8),@b varchar(10),@c numeric(5,2)
)
as
begin
insert into score
values(@a,@b,@c)
end

declare @a numeric(5,2),@b numeric(5,2)
set @a=(select max(成績(jī)) from score)
set @b=(select min(成績(jī)) from score)
print @a-@b