SoftwareTestPilot
LearnCoding RoundsCommunityJobsQA Resources
All questions
BasicSQL~6 min

Orders with no payment record

Realistic payment reconciliation check

Points available

100/100

Your mission

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

Return id and status of orders that have no row in payments.

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

  • Which statuses should never lack a payment?

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