OpSalwarKameez24-5: Bling-Bling

CHALLENGE DESCRIPTION

It’s the festive season of Diwali, and a newly launched website, Bling-Bling Crackers (a fictional site, inspired by platforms like Amazon and Flipkart), is offering huge discounts and free gifts for new users. To celebrate the festival of lights, Deepam Mart has launched a “Diwali Dhamaka” sale, offering ₹1 products, 50% off discounts, and free gifts like Diwali decorations and sweets for first-time users. The company Bling-Bling Crackers uses StoreD.

SOLUTION

Total number of Nodes in the database?

Answer

How many Account nodes does the database have?

Answer

How many accounts are registered from the IP address 88.236.1.190?

Answer

How many Users have created multiple accounts with same IP address?

Answer

What physical address has been used multiple times?

Answer

Which Credit Card number is attached to multiple accounts?

Answer

When was the account with username obhandari created?

Answer

How many accounts using the credit card number from question 6 use the same registered IP address?

Answer