Retrieve customers with multiple orders and top orders
Filed under Tekion
The question
Given Customers and Orders tables linked by a foreign key, write SQL queries to get customers with more than 1 order, the top 3 orders by amount, and all unique items.
No write-up yet. Related questions below have one.
Related Tekion questions
Collected from public candidate posts and coding forums. Updated Nov 2026.