What query or queries would you use to find all repeat customers,change their shipping costs to zero,and then three months from now track their purchases to see if they purchased more over the last three months than the three months before the shipping costs were changed?
A)Update,then crosstab
B)Update,then find duplicates,then crosstab
C)Find duplicates,then crosstab
D)Find duplicates,then update,then crosstab

Question

Quizplus · Accepted Answer

We need to first find all repeat customers, which requires finding duplicates. Then, we can update their shipping costs to zero. Finally, we can use a crosstab query to track their purchases over two different time periods. Therefore, the correct sequence is: find duplicates, update, crosstab. Option D is the only one that includes all three of these steps in the correct order.

What Query or Queries Would You Use to Find All