QUESTION

Customer Segmentation by Frequency of Purchases

Hard

$2x$

$\frac{0}{120}$

Write an SQL query to categorize customers based on the number of unique shopping days they have within the Electronics'product category, using data from the Customers and Orders tables.

While categorization we will only consider those customers who have made any order

Criteria for Customer Categorization based on the no$.$ of unique buying days:

Classify as Frequent Shoppers those who shopped on $8$ or more different days.

Classify as Moderate Shoppers those who shopped between $4$ and $7$ different days.

Classify as Occasional Shoppers those who shopped on fewer than $4$ different days.

Tables Schema as Below:

$\backslash$table$[[$Customers$],[$columnName$,$dataType$],[$CustomerID$,$int$],[$CustomerName$,$varchar $(255)$