SQLeasyAggregations~12m

A SaaS analytics platform wants to understand feature adoption across different...

Problem

A SaaS analytics platform wants to understand feature adoption across different subscription tiers. For each feature, calculate the total number of unique workspaces that have used it, the average daily usage count, and the percentage of Premium workspaces (out of all workspaces that used the feature) that have adopted it. Only include features that have been used by at least 3 different workspaces. Order results by the percentage of Premium adoption descending, then by feature name ascending.

Examples

Example 1

Example 2

Constraints

›Return columns: feature_name, unique_workspaces, avg_daily_usage, premium_adoption_pct
›Only include features used by at least 3 workspaces
›Calculate premium_adoption_pct as percentage of Premium workspaces out of all workspaces that used the feature
›Round avg_daily_usage to 2 decimal places and premium_adoption_pct to 2 decimal places
›Order by premium_adoption_pct DESC, then feature_name ASC

Reference solution

Reference solution available after you attempt the question.

Ready to solve it?

Start a session on Mockbit #47. Write your SQL, run it against real data, and get graded on correctness, efficiency, query structure, and business understanding.