Question

if the coffee shop wants to see the sales ranks for 4 - star robusta - type coffee, which columns should it filter by? (5 points)
options:
filter by coffee type first, then filter by customer rating
filter by customer rating first, then filter by sales rank
filter by customer rating first, then filter by country
filter by sales rank first, then filter by coffee type

the table has columns:
a (not fully visible),
b: country (1: brazil, 2: madagascar, 3: peru, 4: congo, 5: paraguay)
c: coffee type (1: arabica, 2: robusta, 3: arabica, 4: robusta, 5: arabica)
d: sales rank (1: 16, 2: 27, 3: 3, 4: 11, 5: 9)
e: customer rating (1: 4 stars, 2: 2 stars, 3: 4 stars, 4: 3 stars, 5: 3 stars)

Explanation:

Step1: Identify target coffee type

We first filter for Robusta-type coffee (column B), to narrow down the dataset to only Robusta entries: Madagascar (Robusta, 27, 2 stars) and Congo (Robusta, 11, 3 stars).

Step2: Filter for 4-star rating

From the Robusta subset, we then filter by Customer Rating (column D) to find 4-star entries. While no 4-star Robusta exists in the table, this is the correct sequence to meet the requirement of isolating 4-star Robusta-type coffee and viewing their sales ranks.

Answer:

Filter by Coffee Type first, then filter by Customer Rating