MS SQL create a query
Budget: $30 – $250 USD
We need to calculate revenue per week for the following products:
100 - IT Helper without trial (3.3 rubles per day, 50/50 revenue share)
106 - IT Helper trial for 30 days (3.3 rubles per day after the 30-day trial period)
300 - IT Helper tariff with 0-day trial (3.3 rubles per day, 45/55 revenue share)
400 - IT Helper Safe Internet tariff with 0-day trial (9.96 rubles per day, 60/40 revenue share)
401 - IT Helper Safe Internet with 30-day trial (299 rubles per month, 60/40 revenue share)
We need to use window functions for the calculation.
and i can send test data
100 - IT Helper without trial (3.3 rubles per day, 50/50 revenue share)
106 - IT Helper trial for 30 days (3.3 rubles per day after the 30-day trial period)
300 - IT Helper tariff with 0-day trial (3.3 rubles per day, 45/55 revenue share)
400 - IT Helper Safe Internet tariff with 0-day trial (9.96 rubles per day, 60/40 revenue share)
401 - IT Helper Safe Internet with 30-day trial (299 rubles per month, 60/40 revenue share)
We need to use window functions for the calculation.
and i can send test data