Question · SQL and MySQL course · Module 10: Transactions and advanced SQL

Why use a CTE

What is the main advantage of using a CTE in complex queries?

Answer options

  • The query becomes readable - it reads top to bottom, step by step
  • A CTE automatically creates indexes on all columns
  • A CTE encrypts the data before sending it to the client
  • A CTE lets you omit the SELECT keyword in the query

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