SQL · Meta · Easy
Two relational tables store data about posts and the replies made to those posts. Write two SQL queries that answer different questions about reply engagement. The posts table contains: post_id INTEGER — primary key, unique identifier for a post author_id INTEGER — id of the user who created the post created_at TIMESTAMP — creation time in UTC The replies table contains: reply_id INTEGER — primary key, unique identifier for a reply post_id INTEGER — foreign key to…
Checking your access…