Millennium
Interview Question
Software Engineer Interview
Millennium
Given a Product table with columns [ProductId, Name] and records [1, Apple], [2, Orange], [3, Pear], and an Order table with columns [ProductId, Quantity] and records [1, 7], [2, 8], what SQL query produces [ProductId, Name, Quantity] such that the result is [1, Apple, 7], [2, Orange, 8], [3, Pear, 0] (with 0 for products not in the Order table)?
Unlock the Full Solution
Enter your email to get instant access to the complete solution, explanation, and similar practice problems.
