SQL Query #6

Tanner Glazier asked 2 years ago

The question asks us to construct a query to count how many encounters resulted in the customer declining to make a purchase. Is this supposed to include all encounters that did not end in a purchase?
For example if a customer comes into the store, does not make a purchase on that day but comes back at a later date and then makes are purchase, are we supposed to include that first date where no purchase was made in the totals of encounters where the customer declined to make a purchase?   

1 Answers
Cory Anderson answered 2 years ago

Tanner, this query asks for ecounters that did not end in a purchase, not customers who did not purchase thus. you should evaluate the encoutner IDs where purchase = FALSE. Does that make sense?

Your Answer

9 + 16 =

css.php