SQL · Meta · Medium
You have two feed tables to work with. info_stream_views captures each occasion a viewer opened a post, recording how long the view lasted (duration, measured in seconds), how that viewer is connected to the post's author (relationship), and the calendar day (ds). post_reactions captures every like, comment, or reshare a viewer left on a post, also stamped with a day. All days are stored as 'YYYY-MM-DD' text, and both tasks below look only at the window running from…
Checking your access…