Join Tables and Return Matches | Dataford Interview Questions

Microsoft wants a clean list of Surface products currently available for sale. Write a PostgreSQL query that returns the product records matching the required product line and availability criteria.

Requirements

Return products where product_line is Surface and availability is Available.
Return the product ID, name, product line, availability, and list price, sorted alphabetically by product name.

Schema

surface_products

Column	Type	Description
product_idPK	INTEGER	Unique product identifier
product_name	VARCHAR(100)	Product display name
product_line	VARCHAR(50)	Microsoft product family
availability	VARCHAR(30)	Current sales availability
list_price	NUMERIC(10,2)	Product price in US dollars

Your question is Join Tables and Return Matches. 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

Microsoft wants a clean list of Surface products currently available for sale. Write a PostgreSQL query that returns the product records matching the required product line and availability criteria.

Requirements

Return products where product_line is Surface and availability is Available.
Return the product ID, name, product line, availability, and list price, sorted alphabetically by product name.

Schema

surface_products

Column	Type	Description
product_idPK	INTEGER	Unique product identifier
product_name	VARCHAR(100)	Product display name
product_line	VARCHAR(50)	Microsoft product family
availability	VARCHAR(30)	Current sales availability
list_price	NUMERIC(10,2)	Product price in US dollars

Your question is Join Tables and Return Matches. 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.