超级菜鸟前来求救！！！！

create table Books
(
author varchar2(50),
book int
);
insert into Books values (*Tom*,1001);
insert into Books values (*Jack*,1002);
insert into Books values (*Rose*,1003);
insert into Books values (*John*,1002);
insert into Books values (*Smith*,1003);
insert into Books values (*King*,1001);
insert into Books values (*Zhang*,1004);
commit;