Exercise

Syntax order - very large earthquakes

When a query is executed it will stop at the first error it encounters and will return an error message. Because a query is processed in a stepped order the first error it stops at will be related to the processing order.

  • FROM is processed first and checks that the queried table(s) exist in the database.
  • WHERE is always processed after FROM if a row filtering condition is specified. Column(s) having the filtering condition applied must exist.
  • SELECT is only processed once the data is ready to be extracted and displayed or returned to the user.

This exercise has three queries—each contains errors. Your job is to find the errors and fix them.

Note that the red text below the query result tab is a description of the error.

Instructions 1/3

undefined XP
  • 1

    Select Run Code and look at the error produced. Fix the error and select Submit Answer.

  • 2

    Select Run Code and look at the error produced. Fix the error and select Submit Answer.

  • 3

    Select Run Code and look at the error produced. Fix the error and select Submit Answer.