10078 Find Matching Hosts And Guests In A Way That They Are Both Of The Same Gender And Nationality

Interview Core Track · Easy · 15 min

SELECT distinct h.host_id, g.guest_id FROM airbnb_hosts h JOIN airbnb_guests g ON h.nationality=g.nationality and h.gender = g.gender

Interview Core Track

Easy

15 min

joins

filtering

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

Timer 00:00

Practice joins through a Airbnb-tagged business scenario.

Use this track to improve speed, edge-case handling, and accuracy under timed conditions.

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

Prereq: query basics

Prereq: filtering

SELECT distinct h.host_id, g.guest_id FROM airbnb_hosts h JOIN airbnb_guests g ON h.nationality=g.nationality and h.gender = g.gender

host_id INT PRIMARY KEY

nationality VARCHAR(50

guest_id INT PRIMARY KEY

nationality VARCHAR(50

Editor

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

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