Count of Potential and Non-Potential Customers

[sidhiq91]

Hello Guys,

Could anyone help me with the below scenario? I wanted to count the number of Potential and Non-Potential Customers date-wise.

Definitions for Potential and Non-Potential are as follows:

Potential: Potential customers are the ones who have made a purchase.

Non-Potential: Non-Potential Customers are the ones who are visiting the shop but have never made the purchase.

Note:  If customers just visit the store after the first purchase and does not make any purchase is still considered  Potential Customer.

I have attached the screenshot of the sample data for your reference.

Please do help.

Output Table
Date	No of Potential Customers	No of Non-Potential Customers
01-Dec-23	0	1
02-Dec-23	0	1
03-Dec-23	1	0
04-Dec-23	2	0
05-Dec-23	1	1

Purchase Table
Purchase Date	Purchasor ID	Product
03-Dec-23	1	Shampoo
05-Dec-23	3	Pants
04-Dec-23	2	Shirts

Visitors Table
Visitors Date	Visitor ID	Shop Name
01-Dec-23	1	Shop A
02-Dec-23	2	Shop A
03-Dec-23	1	Shop A
04-Dec-23	1	Shop A
04-Dec-23	2	Shop A
05-Dec-23	3	Shop A
05-Dec-23	4	Shop A

[sidhiq91]

Hello Everyone,

Can I get some help on the above request?

Regards,

Sidhiq