Millennium Management–styleSoftware EngineerSoftware EngineerQuestion #3
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)?
Build Your Approach
State the assumptions, try a simple case, then work toward a general solution. Check the result and explain how it changes if an assumption changes.
Try the free diagnostic with worked solutions →Get Free Interview Prep Resources
More Millennium Management–Style Software Engineer Questions
Can you explain the difference between inner and outer joins?Implement a recursive function to compute the nth Fibonacci number.Explain Java collections and how you use them.Given a product table [ProductId, Name] with records [1, Apple], [2, Orange], [3, Pear] and an order table [ProductId, Quantity] with records [1, 7], [2, 8], write the SQL query to produce [ProductId, Name, Quantity] where missing quantities are shown as 0. The output should be: [1, Apple, 7], [2, Orange, 8], [3, Pear, 0].Write a recursive function to compute the nth Fibonacci number.
Practice the Reasoning Behind the Answer
Bring your target roles and interview timeline to a free quant consult. Discuss your preparation priorities and how Quant Blueprint’s lessons, practice and mock interviews can help.
Book a Free Quant ConsultYour goals · your preparation · your next steps