Createtables ([name] nvarchar (50), booknvarchar (50), saledNumberint) insertintos ([name], book, saledNumber) values (Mr. Wang, Excel tutorial, 10 ); insertintos ([name], book, saledNumber) values (Xiao Li, Excel textbook, 15); insertintos ([name], bo
Create table s ([name] nvarchar (50), book nvarchar (50), saledNumber int) insert into s ([name], book, saledNumber) values ('John ', 'excel textbooks ', 10); insert into s ([name], book, saledNumber) values ('lil', 'excel textbooks', 15 ); insert into s ([name], bo
Create table s (
[Name] nvarchar (50 ),
Book nvarchar (50 ),
SaledNumber int
)
Insert into s ([name], book, saledNumber) values ('mr. Wang ', 'excel textbooks', 10 );
Insert into s ([name], book, saledNumber) values ('lil', 'excel textbooks ', 15 );
Insert into s ([name], book, saledNumber) values ('wang ', 'word textbooks', 8 );
Insert into s ([name], book, saledNumber) values ('lil', 'excel textbooks ', 7 );
Insert into s ([name], book, saledNumber) values ('mr. Wang ', 'excel textbooks', 9 );
Insert into s ([name], book, saledNumber) values ('lil', 'excel textbooks ', 2 );
Insert into s ([name], book, saledNumber) values ('mr. Wang ', 'word textbook', 3 );
Insert into s ([name], book, saledNumber) values ('lil', 'excel textbooks ', 5 );
,