question

pearlzil86 avatar image
pearlzil86 asked

SQL query problem: Only first 3 active affiliate commision out of 10000 recruits is calculated and only for first 3 sales from each recruits?

Create a database query to recruit Mike in the business and they recruited 200 individuals as their business affiliates. The first active individual who made their $100.00 monthly membership fee would be credited to me and I would receive $80.00 monthly from the membership payments. Mike would receive the other $80.00 monthly from his remaining 199 active business affiliates.
Note: If Mike went on and recruited a 10000 business affiliates, only get his first three active affiliates and Mike would benefit from the remaining 999.997 active affiliates he recruited.

databasesql databasesqlquery
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.