difficolta con select

[colde]

SELECT email.email, rifiutate.email FROM EMAIL Where email <> 'Not disclosed' AND Email not Like '%piazzaerbestore%' AND email NOT LIKE '%/%' AND email NOT LIKE 'www.%' AND Email Like '%@%'and email <> rifiutate GROUP BY email;


oppure

SELECT email, rifiutate FROM EMAIL Where email <> 'Not disclosed' AND Email not Like '%piazzaerbestore%' AND email NOT LIKE '%/%' AND email NOT LIKE 'www.%' AND Email Like '%@%'and email <> rifiutate GROUP BY email;



Prova così ma non assicuro niente.