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 · Window functions

Given a page_views table with user_id, page_url, and view_ts, write a query that returns the most common page-to-page navigation path (sequences of exactly two pages) across all users.

Type your answer

0of ~140 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

Your answer appears here as you speak.

Given a page_views table with user_id, page_url, and view_ts, write a query that returns the most common page-to-page navigation path (sequences of exactly two pages) across all users.

Practice more