extrar cantidad de registros diferentes

[Libras]

y cual es el error? El error es que no valido mis codigos de mysql y las sentencias son diferentes entre manejadores de datos :P

Código MySQL:

create table tabla
(
correo varchar(300)
);
 
insert into tabla values ('[email protected]');
insert into tabla values ('[email protected]');
insert into tabla values ('[email protected]');
insert into tabla values ('[email protected]');
insert into tabla values ('[email protected]');
insert into tabla values ('[email protected]');
insert into tabla values ('[email protected]');
insert into tabla values ('[email protected]');
insert into tabla values ('[email protected]');
insert into tabla values ('[email protected]');
insert into tabla values ('[email protected]');
insert into tabla values ('[email protected]');
 
 
 
 
 
(SELECT  completo, correo FROM(
SELECT SUBSTRING(correo1,1,INSTR(correo1,'.')-1) AS completo, correo FROM(
SELECT SUBSTRING(correo, INSTR(correo,'@')+1, length(correo)) AS correo1, correo FROM tabla
) AS t1
) AS t2 WHERE completo='outlook' limit 2)
UNION all
(SELECT  completo, correo FROM(
SELECT SUBSTRING(correo1,1,INSTR(correo1,'.')-1) AS completo, correo FROM(
SELECT SUBSTRING(correo, INSTR(correo,'@')+1, length(correo)) AS correo1, correo FROM tabla
) AS t1
) AS t2 WHERE completo<>'outlook' group by completo)
 

Resultado:
Completo correo
outlook [email protected]
outlook [email protected]
yo [email protected]
tu [email protected]
otro [email protected]
aja [email protected]