Question · SQL and MySQL course · Module 7: Joining tables (JOIN)

Where we give an alias

Where in the query do we give a table its alias?

Answer options

  • Right after the table name, after a space - e.g. ksiazki k
  • At the very beginning, before the word SELECT
  • Only inside the ON clause
  • The alias must be written in UPPERCASE in parentheses

You can check the correct answer by solving this task in the CodeWorlds game.