SQL · Meta · Medium
Assume you have the following two tables in a PostgreSQL database: A row in posts represents one feed impression. view_id identifies the viewer, relationship indicates whether the content author was a 'friend' or an 'unconnected' account, and post_date is the UTC date the impression occurred. A row in interactions represents one action taken on the impression matching view_id. For this task, only interaction_type = 'like' and interaction_type = 'comment' are considered…
Checking your access…