New
The Learning module is now live
See what's new
×
Question Bank
Learning
NEW
Pricing
Blog
Forum
HOT
JobRadar
Description
Solution
Discussion
Submissions
Ask AI
Question Bank
Airbnb
SQL Question
AI Insights
Quick Summary
Match rentals to searches based on complete amenity requirements.
Rentals may contain extra amenities but must satisfy every required item.
Return matching pairs sorted by search and rental identifiers.
What This Tests
Relational set intersection logic
Aggregation and conditional filtering
Correlated subqueries or self-referential counting
Handling one-to-many relationships across tables
Common Patterns
Inner Join
Aggregation
HAVING Filter
Correlated Subquery
Collapse
Hint 1
Hint 2
What Interviewers May Ask Next
Ask AI Assistant
Ask AI Assistant
Ask me anything about this coding question!
Qwen
Qwen3.7-Flash
0/2000
Run
Submit
Test Cases
SQL Schema
Pandas Schema
Input
-
Output
-
Expected
-
