tpcds-kit icon indicating copy to clipboard operation
tpcds-kit copied to clipboard

query91 mismatch between business question and SQL code

Open gregrahn opened this issue 11 years ago • 0 comments

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 avatar Feb 22 '14 01:02 gregrahn