create table s( [name] nvarchar(50), book nvarchar(50), salednumber int ) insert into s ([name],book,salednumber) values('小王','excel教材',10); insert into s ([name],book,salednumber)values('小李','excel教材',15); insert into s ([name],bo
create table s(
[name] nvarchar(50),
book nvarchar(50),
salednumber int
)
insert into s ([name],book,salednumber) values('小王','excel教材',10);
insert into s ([name],book,salednumber)values('小李','excel教材',15);
insert into s ([name],book,salednumber)values('小王','word教材',8);
insert into s ([name],book,salednumber)values('小李','excel教材',7);
insert into s ([name],book,salednumber)values('小王','excel教材',9);
insert into s ([name],book,salednumber)values('小李','excel教材',2);
insert into s ([name],book,salednumber)values('小王','word教材',3);
insert into s ([name],book,salednumber)values('小李','excel教材',5);
，