[rckoepke]

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=961...

[falco925]

Yea, 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.