Quantiphi Interview Question

Round 3: In person technical round System design (basic workflow) of a project SQL query having an operation consisting of: joins, group by, having, limit, order by clause (2 and three table operation) Solve it any way you like question (Was given a question involving a large database containing 80-90 records of football matches, along with three questions based on that table. When I asked how he expects me to solve this question, he said to solve it using any programming skills I have). Solved it using hash maps. LRU cache (typical leetcode problem) [Doubly linked list] Some work environment related conversation; contribution of open source to your overall technical expertise. Security related questions based on the project.