Millennium ManagementSoftware EngineerSoftware EngineerQuestion #7
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].
Unlock the Full Solution
Enter your email to get the detailed step-by-step solution to this Millennium Management interview question, plus access to free interview prep resources.
We'll also send you a free HFT mock interview video.
More Millennium Management Software Engineer Questions
Can you explain the difference between inner and outer joins?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)?Implement a recursive function to compute the nth Fibonacci number.Explain Java collections and how you use them.Write a recursive function to compute the nth Fibonacci number.
Get All 18+ Millennium Management Questions with Solutions
Plus 16+ hours of video lectures, resume tailoring, and 1:1 mentorship from quants.
Schedule a Call