9629 Find The Count Of Verified And Non Verified Airbnb Hosts

Airbnb

Foundations Track · Easy · 15 min

SELECT host_identity_verified, COUNT(id) as n_hosts FROM airbnb_search_details GROUP BY host_identity_verified -- NOTE: very easy; shouldn't be in the Medium...

Foundations Track

Easy

15 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 host_identity_verified, COUNT(id) as n_hosts FROM airbnb_search_details GROUP BY host_identity_verified -- NOTE: very easy; shouldn't be in the Medium section

airbnb_search_details

id INTEGER PRIMARY KEY

host_identity_verified VARCHAR(10

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.