SELECT * FROM autor WHERE nachname <> '' AND name LIKE 'Ambros Johannes'
 

Ambros Johannes