For example, to use left joins between characters and tv shows with aliases, you would run:

SELECT

c$.$name,

t$.$name

FROM character AS c

LEFT JOIN character$\_$tv$\_$show AS ct

ON

c$.$id $=$ ct$.$ character$\_$id

LEFT JOIN tv$\_$show AS t

ON ct$.$tv$\_$show$\_$id $=$

t$.$id;

As you can see, it is shorter than the query in the previous exercise.

Can you use left joins to match character names with the actors that play them, and use aliases to make the query shorter? The aliases for character, character$\_$actor, and actor should be c$,ca,$ and $a.$

Select the columns:

c$.$name,

a$.$name