Basic SQL Queries | Dataford Interview Questions

Write basic SQL queries and explain how you would use table joins.

Use the vehicle_listings table to return active CarGurus listings in Boston priced at or below $30,000. Also explain when an INNER JOIN and a LEFT JOIN would be appropriate when related listing tables are available.

Output

One row per qualifying listing with listing_id, make, model, price, and city
Exclude inactive listings, listings outside Boston, listings without a price, and listings above $30,000
Order by price ascending, then listing_id ascending

Schema

vehicle_listings

Column	Type	Description
listing_idPK	INT	Unique identifier for the vehicle listing
make	VARCHAR(50)	Vehicle manufacturer
model	VARCHAR(80)	Vehicle model
price	NUMERIC(10,2)	Advertised vehicle price in US dollars
city	VARCHAR(80)	City where the vehicle is listed
is_active	BOOLEAN	Whether the listing is currently active

Your question is Basic SQL Queries. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem

Write basic SQL queries and explain how you would use table joins.

Output

One row per qualifying listing with listing_id, make, model, price, and city
Exclude inactive listings, listings outside Boston, listings without a price, and listings above $30,000
Order by price ascending, then listing_id ascending

Schema

vehicle_listings

Column	Type	Description
listing_idPK	INT	Unique identifier for the vehicle listing
make	VARCHAR(50)	Vehicle manufacturer
model	VARCHAR(80)	Vehicle model
price	NUMERIC(10,2)	Advertised vehicle price in US dollars
city	VARCHAR(80)	City where the vehicle is listed
is_active	BOOLEAN	Whether the listing is currently active

Your question is Basic SQL Queries. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.