Coach note
Interviewers ask this kind of question to surface how you think, not what you remember. The strongest answers are specific, calmly told, and end on what changed.
SQL · Subqueries
Given a posts table with post_id, author_id, parent_post_id (for replies), and created_at, write a query that returns the top 10 posts by total engagement, where engagement includes the post itself plus all nested replies.
Type your answer
0of ~150 wordsAbout a minute spoken
Voice isn’t supported in this browser — type your answer in the box.
Create a free account to get more critiques.
Your answer appears here as you speak.