The loyalty team wants to identify highly engaged customers…
The loyalty team wants to identify highly engaged customers — specifically those who have purchased products from 3 or more different product categories. Write a query showing:customer_name, membership_level, categories_purchased Only include customers who have purchased from 3 or more distinct categories.Sorted by categories_purchased descending, then customer_name ascending. Tables: customers, purchases, products