ACCPS2优化MYSCHOOL数据库设计第三章练习题

--1.
declare @star nvarchar(255)
set @star='★'
declare @i int
set @i=1
while(@i<6)
begin
print @star
set @star+='★'
set @i+=1
end
go
declare @star nvarchar(255)
set @star='★'
declare @i int
set @i=1
declare @j int
set @j=0
while(@i<6)
begin
while(@j<@i)
begin
print @star
set @star+='★'
set @j+=1
end
set @i+=1
end
go
--2.
create table tmp(rq varchar(10),shengfu nchar(1))
select * from tmp
insert into tmp values('2005-05-09','胜')
insert into tmp values('2005-05-09','胜')
insert into tmp values('2005-05-09','负')
insert into tmp values('2005-05-09','负')
insert into tmp values('2005-05-10','胜')
insert into tmp values('2005-05-10','负')
insert into tmp values('2005-05-10','负')
select rq,SUM(
case
when shengfu='胜' then 1
else 0
end),SUM(case
when shengfu='胜' then 0
else 1 end)
from tmp group by rq