I’ve put together these additional queries for you to work on, pick 2 questions to answer….
I’ve put together these additional queries for you to work on, pick 2 questions to answer….
/>
e. What queries might be useful to determine which customer is a high-volume buyer of Woodcraft’s products?
f. How might you extract only customers who are preferred customers?
g. Let’s say you want to run a test promotion within a certain city, how might you determine which customers live in that city?
h. If you were to run a promotion to all buyers who were affiliated with churches, what would your query look like?
i. How might you isolate only those customers who have incomes over $40,000 and are involved in scouting?