tpcds-kit
tpcds-kit copied to clipboard
query91 mismatch between business question and SQL code
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'))