If you want to use an alias for a column, you add AS after the column name.
If we wanted to use left joins between character names and TV shows and clearly denote which column has character names, and which has TV show names, it would look like this:
SELECT character. name AS character, tv_show. name AS name FROM character
LEFT JOIN character_tv_show
ON
character.id = character_tv_show.character_id
LEFT JOIN tv_show
ON character_tv_show.tv_show_id = tv_show.id;
Can you use left joins to match character names with the actors that play them, and use aliases to call the two columns returned character and actor?