10159 Ranking Most Active Guests

Airbnb

Foundations Track · Medium · 25 min

SELECT id_guest, SUM(n_messages) as sum_n_messages, DENSE_RANK() OVER(ORDER BY SUM(n_messages) desc) as ranking FROM airbnb_contacts GROUP BY id_guest ORDER ...

Foundations Track

Medium

25 min

aggregation

Company labels are directional practice context, not official interview guidance.

Timer 00:00

Back to practice

Objective

Practice aggregation through a Airbnb-tagged business scenario.

Approach

Use this track to lock in clean query structure, basic filtering logic, and confidence with grouped output.

Company context

Company labels are directional practice context, not official interview guidance.

Prereq: query basics

Prereq: filtering

SELECT id_guest, SUM(n_messages) as sum_n_messages, DENSE_RANK() OVER(ORDER BY SUM(n_messages) desc) as ranking FROM airbnb_contacts GROUP BY id_guest ORDER BY sum_n_messages desc

Pro question

This is a Pro question

Upgrade to Pro to unlock this prompt, the SQL workspace, and all 254 problems.

Upgrade to Pro — unlock all 254 problems

Editor

SQL workspace

Run queries against the protected question data, then submit once the result shape looks right.

Sign in to run SQL

Create a free account or sign in before running queries against protected question data.