SoftwareTestPilot
LearnCoding RoundsCommunityJobsQA Resources
All questions
BasicSQL~4 min

Find records with missing emails

Common data-validation check in database testing interviews

Points available

100/100

Your mission

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

Return id and name of customers whose email is NULL or an empty string.

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

  • How would you find invalid emails without '@'?

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