I have the following question: "Enter the" name3 "which are in ALL" name ".
And I have 4 tables that are below
-- A (name,Num2, local)
insert into A values ('Favela',1,'WE');
insert into A values ('Lamosa',2,'NA');
insert into A values ('Luz',3,'S0');
-- E (num4,name3,name4,num5)
insert into E values (1,'Teresa','Reino',1);
insert into E values (6,'Maria','Filo',1);
insert into E values (7,'Francisca','Ordem',6);
insert into E values (8,'Rita','Ordem',6);
insert into E values (9,'Beatriz','Ordem',6);
insert into E values (10,'Sofia','Filo',1);
insert into E values (11,'Bea','Ordem',10);
-- C (num5,num3,name2,num4)
insert into C values (2,1,'Cao',9);
insert into C values (1,2,'Gato',8);
insert into C values (1,3,'Golfinho',7);
insert into C values (3,4,'Peixe',11);
-- B (Num1,name,Num2, Num3)
insert into B values (1,'Maria',1,1);
insert into B values (2,'Jorge',2,1);
insert into B values (3,'Teresa',2,1);
insert into B values (4,'Rui',3,1);
insert into B values (1,'Fran',3,3);
insert into B values (2,'Juliett',3,3);