Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

query91 mismatch between business question and SQL code #6

Open
gregrahn opened this issue Feb 22, 2014 · 0 comments
Open

query91 mismatch between business question and SQL code #6

gregrahn opened this issue Feb 22, 2014 · 0 comments
Assignees
Labels

Comments

@gregrahn
Copy link
Owner

The business question for query91 states:

Display total returns of catalog sales by call center and manager in a particular month for male customers of unknown education or female customers with advanced degrees with a specified buy potential and from a particular time zone.

However the SQL contains

and     ( (cd_marital_status       = 'M' and cd_education_status     = 'Unknown')
        or(cd_marital_status       = 'W' and cd_education_status     = 'Advanced Degree'))

For male/female customers the query should use cd_gender and not cd_marital_status like such:

and     ( (cd_gender       = 'M' and cd_education_status     = 'Unknown')
        or(cd_gender       = 'F' and cd_education_status     = 'Advanced Degree'))
@gregrahn gregrahn added the bug label Feb 22, 2014
@gregrahn gregrahn self-assigned this Feb 22, 2014
@gregrahn gregrahn changed the title query91.tpl mismatch between business question and SQL code query91 mismatch between business question and SQL code Jun 10, 2017
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant