Millennium Management Interview 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.

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.

You have a 6-hour case exercise with the following tasks: 1) Download the latest ADV reports from the SEC website and parse them to extract information about various funds, including name, address, phone number, and number of employees. 2) Implement error logging and write log entries to a local SQLite file. 3) Clean and transform the data to extract insights such as fund size by assets under management (AUM) and number of employees. 4) Create an API to expose the processed data. 5) Write mock tests for the API. 6) Create visualizations based on the extracted data.