Search an Author by Name and the Books that Author Wrote - mysql

Based on the images below, find the book that John Steinbeck wrote.

Book table:

Book_has_author table:

Author table:

ISBN Tite Cost ReservedWear LOCATION_idLOCATION PUBLISHER_idPUBLISHER CHECKOUT idCHECKOUT 13.89 N 97819271839711 9781927183971 East of Eden 97845678901231 1234567890123 Alice in Wonderland 5.50 N G 517 G 121 NULL NULL 59382 93801 HULL HULL r4jybe3oxsn48r2 HULL NULL NULL NULL NULL