All ideas
Data not visable issue
SELECT year, week_num, num_users, SUM(numusers) OVER (ORDER BY year, weeknum) AS cum_users FROM ( SELECT EXTRACT(YEAR FROM created_at) AS year, EXTRACT(WEEK FROM createdat) AS weeknum, COUNT(DISTINCT userid) AS numusers FROM users WHERE state = 'active' GROUP BY year, week_num ORDER BY year, week_num ) AS subquery_alias; -- Added alias for the derived table when i run this code ,it's working fine but output is not visiable so what i want to do in this issue plz reply fast and me some solutation
