← Oracle questions
CodingReported in a candidate post, Oct 2024

Find the user whose video has the most comments

Filed under Oracle

Given tables users(id, name), videos(id, user_id) and comments(id, video_id), write a SQL query that returns the name of the user whose video has the most comments. (Table names are assumed; the…

You've read your 3 free write-ups

Sign up free to keep reading. Your account opens the first 10 questions of every company.

Related Oracle questions

Collected from public candidate posts and coding forums. Updated Nov 2026.