SoftwareTestPilot
LearnCoding RoundsCommunityJobsQA Resources
All questions
BasicSQL~7 min

Total spend per customer

Frequent reporting query in e-commerce QA interviews

Points available

100/100

Your mission

  1. Read
  2. 2Run
  3. 3Submit
  4. 4Solve

Return each customer's name and total_spent (sum of order totals) for customers with at least one order.

Sort by total_spent descending, then name ascending.

Runs on the QA Shop practice database (customers, products, orders, order_items, payments, employees, bugs, test_runs, audit_log). Each run starts from a fresh copy.

Hints

Each hint costs 10 points on a full solve.

Interviewer follow-ups

  • Only include delivered orders.
  • Top 3 customers only.

Ctrl+Enter to run · add Shift to submit

1
2
Tab inserts two spaces. Press Escape, then Tab, to leave the editor.
Terminal

$ sqlite3 qa-shop.db < solution.sql

Run executes the open file. Submit scores solution.sql against hidden tests.

SoftwareTestPilot

Learn QA, prove your skills, connect with testers and grow your career.

Platform
  • Learn
  • Community
  • Jobs
Resources
  • QA Resources
  • Interview Questions
  • QA Tools
  • Articles
  • Products
Company
  • About
  • Contact
  • Authors & Reviewers
  • Editorial Policy
  • Sitemap
© 2026 SoftwareTestPilot. All rights reserved.
Operated by SoftwareTestPilot · Pune, Maharashtra, India · softwaretestingsapiens@gmail.com
PrivacyTermsCookiesDisclaimerRefundsAccessibility