1. Learn
    2. /
  2. Courses
    3. /
  3. SQL Tutorial for Marketers

Exercise

Formulating Queries (2)

You saw how to formulate a query correctly, but what would happen if you submit the code to the right?

You see that you get two types of errors:

  • SQL errors are shown below the editor: these are errors returned by the SQL engine. For example, 
syntax error at or near "'I <3 SQL'" LINE 2: 'I <3 SQL' ^


  • Besides SQL errors, there are also DataCamp errors are shown in the Instructions box. These will let you know in plain English where you went wrong in your code! For example, 
You need to add SELECT at the start of line 2!

Note that you won't see the former erors if you're working in a real-life database ;) This is just to help you get started with SQL!

Instructions

100 XP

Submit the code to the right, check out the errors, then fix them!