 	FROM "atomic".events
 	WHERE event='transaction'
 	GROUP BY 1,2,3 ) AS t -- deduped transaction table
-GROUP BY 1
+GROUP BY 1;
 
 
 -- MEASURING USER ENGAGEMENT
 -- Users by number of days per month visit website
-CREATE VIEW engagement_users_by_days_per_month_visit_website AS
+CREATE VIEW engagement_users_by_days_p_month_on_site AS
 SELECT
 "Month",
 "Days_visited_website",

ORDER BY 1,2;

-- Users by number of visits per week
CREATE VIEW engagement_users_by_visits_per_week
SELECT
"Week",
"Visits_per_week",



-- Users by number of days per week visit website
CREATE VIEW engagement_users_by_days_p_week_on_site AS
SELECT
"Week",
"Days_visited_website",
