SELECT * FROM autor WHERE nachname <> '' AND name LIKE 'Adami Erich'
 

Adami Erich