text: SELECT
     username,
     posts,
     LAST_VALUE (posts) OVER (
        PARTITION BY username 
        ORDER BY posts
        RANGE BETWEEN UNBOUNDED PRECEDING AND 
        UNBOUNDED FOLLOWING
      ) most_posts
  FROM
      social_media;