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