3 ms·
One AirBNB SQL question prompt is: "Find the search details made by people who searched for apartments designed for a single-person stay."[0] This could be int
by rckoepke 6y ago
One AirBNB SQL question prompt is:
"Find the search details made by people who searched for apartments designed for a single-person stay."[0] This could be interpreted to mean some refined version of the following:
select * from airbnb_search_details
WHERE accommodates = 1
AND property_type LIKE 'Apartment';
However, the expected output includes non-apartments, for example Houses. The expected output matches the following query instead:
SELECT * FROM airbnb_search_details
WHERE accommodates = 1
AND beds = 1;
What do you think users should take away from the experience of completing this question?
0: https://platform.stratascratch.com/edu-content-editor?id=9615&python= https://platform.stratascratch.com/edu-content-editor?id=961...
- falco925 6y agoYea, I completely understand what you're talking about. There's many "solutions" because sometimes there's no real solution. In practice and in an interview, often times it's about a dialogue and aligning with an approach and assumptions. My implementation of having 1 solution isn't good enough. I plan on adding a discussion forum to discuss these exact topics.