sqlteaching
sqlteaching copied to clipboard
Misunderstanding in the phrasing of exercise in Lesson 28: LIKE
Lesson 28: LIKE
Issue
The exercise in this lesson asks us to Can you run a query that returns "Robot" followed by a year between 2000 and 2099?
The phrasing in this sentence is such that we should return entries that are LIKE "Robot 20__", but it expects us to return a query with LIKE "%Robot 20__" i.e., the query should return results containing Robot followed by the year.
Fix
A change in the phrasing to Can you run a query that contains "Robot" followed by a year between 2000 and 2099? It helps understand the problem statement better.
Sorry if this wasn't the right way to open and write an issue.