國家開放大學(數(shù)據(jù)庫基礎與應用)問答題每日一練(2020.05.30)

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

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(成績) from score)
set @b=(select min(成績) from score)
print @a-@b