easy · ~8 min
Product wants a feature adoption report showing what share of current active_users used each catalog feature at least once.
active_users
Write a query that reports adoption per feature:
feature
features
adopters = 0
adoption_pct = 0.00
adopters
feature_usage
adoption_pct = ROUND(adopters * 100.0 / total_active_users, 2)
total_active_users
adoption_pct
Input contract: feature is unique and non-null in features; user_id is unique and non-null in active_users (which is non-empty); usage_id is unique and non-null in feature_usage; all columns are non-null. A user can log multiple rows in feature_usage for the same feature, and feature_usage may contain user_id values not found in active_users.
user_id
usage_id