Dataford
Popular roles
Software EngineerData AnalystData ScientistData EngineerBusiness AnalystAI EngineerMachine Learning EngineerProduct Manager
Browse
Browse All RolesEvery role hub, from analyst to MLBrowse All CompaniesCompany-specific interview loopsAll Interview GuidesThe full guide library
Top questions by role
Software EngineerData AnalystData ScientistData EngineerBusiness AnalystAI EngineerMachine Learning EngineerProduct Manager
Top questions by skill
SQLPythonStatisticsMachine LearningA/B TestingSystem DesignGenerative AIProduct SenseMetricsBehavioral
Browse all questions →Try a mock interview
ExperiencesCoaching
New
Practice
Mock InterviewsTimed interview simulations with feedbackSuccess PathYour 6-week structured planModulesCurated lessons by topicWebinarsTalks from ex-Big Tech data leadsPlaygroundA free-form scratch editor
Learn
BlogInterview strategy and career adviceTech Job Market ReportHiring trends across data and AI rolesFor UniversitiesDataford for career centersAbout DatafordWho we are and how we build
Pricing
Get started
Apartment Listings API Field Mapping
00:00
5 left

Apartment Listings API Field Mapping

MediumSQL · PostgreSQL

Problem

You want to query an API endpoint to receive data about currently available apartment listings from a rental website; num_bedrooms is 1 for a 1-bedroom and 0 for a studio, so how would you query and transform this field for downstream use?

Use the provided listing and rental source tables. Treat unexpected or missing bedroom counts as Unknown.

Output

  1. One row per currently available listing
  2. Columns: listing_id, source_name, and transformed bedroom_type
  3. Sort by listing_id ascending

Schema

apartment_listings
ColumnTypeDescription
listing_idPKINTUnique apartment listing identifier
source_idINTIdentifier of the rental listing source
titleVARCHAR(200)Listing title from the API response
num_bedroomsINTNumeric bedroom count, where zero represents a studio
availability_statusVARCHAR(30)Current availability status
rental_sources
ColumnTypeDescription
source_idPKINTUnique rental website identifier
source_nameVARCHAR(100)Readable rental website name
Tablesapartment_listingsrental_sources
Interviewer

Whenever you're ready, walk me through your approach or go straight to the code. The requirements and the two tables are in the Question tab.

You need to log in / sign up to run or submit.
CodePostgreSQL
Sign up free to run your codeLog inLn 1
Run your query to see results here.