SQL趣味练习题

--第一中情况 
create table renwu
(
name varchar(20) not null,
fahter varchar(20)
)
insert into renwu values('小甲','大甲');
insert into renwu values('大甲','老甲');
insert into renwu (name)  values('老甲');

insert into renwu values('小乙','大乙');
insert into renwu values('大乙','老乙');
insert into renwu (name)  values('老乙');
insert into renwu values('小丙','大丙');
insert into renwu values('大丙','老丙');
insert into renwu (name)  values('老丙');
insert into renwu values('小丁','大丁');
insert into renwu values('大丁','老丁');
insert into renwu (name)  values('老丁');
insert into renwu values('小戊','大戊');
insert into renwu values('大戊','老戊');
insert into renwu (name)  values('老戊');
insert into renwu values('小己','大己');
insert into renwu values('大己','老己');
insert into