WHERE clause: Is my query missing something?

[Admin]

This is the database structure for the problem:

[caption id="attachment_376" align="aligncenter" width="1920"] Source: https://www.coursera.org/learn/sql-for-data-science%5B/caption%5D

Here is the problem:

Write and run a query, with no starter code to answer this question: What Step are Job Codes 0110-0400? Hint: there are 6 lines to run this query.

Here is my query:

SELECT Job_Code, step
FROM  salary_range_by_job_classification
WHERE Job_Code = '0110-0400'

Since it is mentioned with the problem that there are 6 lines to run this query and mine have 3 lines, am I missing something?

---

Reply

---

Perhaps six lines hint isn’t helpful until you learn indenting. Refer https://www.w3schools.com/sql/sql_between.asp5

Perhaps you need:

Where Job_Code between 0110 and 0400

 

[Author]

Posts