CREATE VIEW "activitydistravgsview" ("activity", "avg_time_spent", "process_name")  AS
       SELECT "activitydistrcompview"."activity", AVG(time_spent), "activitydistrcompview"."process_name"
       FROM "activitydistrcompview"
       GROUP BY activity, process_name
GO
GRANT SELECT ON  [dbo].[activitydistravgsview] TO [aionadmin_group]
GO