[SQL문제풀기] Matching Similar Hosts and Guests

문제

StrataScratch - Matching Similar Hosts and Guests

StrataScratch

https://platform.stratascratch.com/coding/10078-find-matching-hosts-and-guests-in-a-way-that-they-are-both-of-the-same-gender-and-nationality/official-solution?code_type=1

내가 작성한 정답

MySQL, PostgreSQL, Oracle

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
order by 1;