Skip to content

First question in Operator Precedence is confusing #29

@AMGitName

Description

@AMGitName

Hello. The first question in SQL Deep Dive/Operator precendence/questions.sql is a bit misleading after the update.

* Select people either under 30 or over 50 with an income above 50000
[added later on] Include people that are 50
* that are from either Japan or Australia

There are 3 options to read this after the update for their location filter:

  • People under 30 or over/at 50 from either Japan or Australia
  • People over/at 50 from either Japan or Australia
  • People at exactly 50 from either Japan or Australia

The solution clearly reveals the logic that should be applied (location should apply to the entire range group <30 and >=50).
Please consider question update to avoid confusion for the students.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions