Advertisement
AnnaCh1971

Странный код для LAG курс 2 тема 6

Nov 23rd, 2022
121
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. WITH users_cnt AS
  2.    SELECT session_start::date AS session_date,
  3.           COUNT(DISTINCT user_id) AS users_cnt
  4.    FROM online_store.sessions
  5.    GROUP BY session_date
  6. )
  7. SELECT *,
  8.       LAG(users_cnt, 7) OVER (ORDER BY session_date) AS previous_weekday_users_cnt
  9. FROM users_cnt;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement