SQL · Airbnb · Easy
Problem A rental platform has two tables that track amenities. The first, rental_amenity, records every amenity offered by a property. The second, search_amenity, records every amenity a user requires in a search. Identify every valid pairing of a search and a rental. A rental is a match for a search when it provides all of the amenities the search demands. The rental may also have extra amenities beyond what was requested. Return the resulting table with two columns:…
Checking your access…