What is a foreign key?
there is instead just one column that links the same concepts
How do you join two SQL tables?
add join to the wend and the using keywords and specify how they can be joined
How do you temporarily rename columns or tables in a SQL statement?
use the as keyword to change the alias of the column