How do you write SQL query to get customers and which categories they did not purchase? How would you find potential new customers in those categories?

Question

Accepted Answer

To get customers and categories they did not purchase, use SQL query with LEFT JOIN and WHERE NOT EXISTS. To find potential new customers, analyze categories with low sales.

Use LEFT JOIN to combine customers and categories tables
Use WHERE NOT EXISTS to filter out categories that customers did not purchase
To find potential new customers, analyze categories with low sales and target marketing efforts towards them