Job description
For the purpose of internal reporting, I will commission the preparation of several database queries.
Reports(queries) to be prepared:
- users
- active users per day
- average of examples made
- number of registrations per day
- most popular (progress of users)
- top 3 courses(+ by language)
- top 10 lessons(+ by language)
- top 10 examples in a given language
- learning mode
- time of day/learning
- sales
- monthly
- monthly by language
- total per year
- number of repeat buyers
- average time to buy again after previous subscription ends
- average time to purchase after registration
- number of users with more than one language