How to modify SQL query with renaming of fields in tables joined via JOIN?

Question

SQL

Removed books from tables for quick understanding -
books (id, name, author_id, genre_id)
authors - authors (id, name)
genres - genres (id_name)
query

SELECT * FROM `books` 
 JOIN `authors` ON (`books`.`author_id` = `authors`.`id`)
 JOIN `genres` ON (`books`.`genre_id` = `genres`.`id`)

returns the name of the genre in the `name` field, how to use aliases correctly?

Answer 1

SELECT books.*, authors.name as aName, genres.name. as gName  FROM `books` 
 JOIN `authors` ON (`books`.`author_id` = `authors`.`id`)
 JOIN `genres` ON (`books`.`genre_id` = `genres`.`id`)