InterviewDigestSystem Design2026-08-13
Database design and query questions
AI-Expanded — inferred from the question title, not from the original candidate report
Design a relational database schema for an e-commerce platform that supports users, products, and orders, ensuring proper normalization to handle one-to-many and many-to-many relationships. Once the schema is defined, write a SQL query to identify the top three customers who have spent the most money in the last thirty days, including their total order value.
Context & Summary
System design and technical deep dive round
💻 Coding practice works best on desktop.
Code editors are too cramped on mobile screens.
Conceptual Question
This appears to be a conceptual, design, or behavioral question rather than an algorithmic coding problem. The code editor and automated test cases have been disabled for this question.
Back to questions