• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Datannum

Data science and web development for small business applications

  • Home
  • Microsoft Excel (spreadsheet) forum
    • Project: Analyze NYSE Data
  • SQL forum
    • Project: Query a Digital Music Store Database
  • Data Visualization
    • Project: Data Visualization Project using Tableau
    • IBM – Cognos Analytics/Planning Analytics/Cognos Controller with Watson
  • Linear Algebra forum
    • Curated resource to learn linear algebra
  • Hire Us/Support

WHERE clause: Is my query missing something?

Data Science/Business Analytics for Small Business Applications › Forums › SQL › WHERE clause: Is my query missing something?

Tagged: WHERE clause in SQL

  • This topic is empty.
Viewing 1 post (of 1 total)
  • Author
    Posts
  • April 19, 2022 at 8:00 am #125
    Admin
    Keymaster

      This is the database structure for the problem:

      [caption id="attachment_376" align="aligncenter" width="1920"]between clause sql 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'

      between clause sql

      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
    Viewing 1 post (of 1 total)
    • You must be logged in to reply to this topic.
    Log In

    Primary Sidebar

    profile for Techcosec Limited on Stack Exchange, a network of free, community-driven Q&A sites

    RSS CS50’s Introduction to Computer Science by Harvard University on Edx

    • Are pairs array and lock array similar in structure after execution of sort_pairs function? Is my base case okay with pairs array or do I need to modify with referencing to lock array? May 27, 2023
    • Recursion in lock-pairs function while drawing analogy with sum of natural numbers: What will be the recursive case May 25, 2023
    • Understanding recursive function with Tideman May 24, 2023
    • More explanation for the Tideman project May 22, 2023
    • Why the below for loop not leading to segmentation fault or garbage value and instead giving correct output May 21, 2023

    Subscribe via Email

    Enter your email address to subscribe and receive notifications of new posts by email.

    This website hosted on WP Engine

    Footer

    Editor’s choice

    Developer jobs remote full time
    • Terms
    • Privacy
    • Disclaimer