fai 2 query prima

SELECT * FROM clienti WHERE cognome IN (SELECT cognome FROM clienti WHERE cognome LIKE '%lau%') ORDER BY cognome;

e poi


SELECT * FROM clienti WHERE cognome NOT IN (SELECT cognome FROM clienti WHERE cognome LIKE '%lau%') ORDER BY cognome;