SQL Quest › SQL Interview Questions › Querying Basics
Passengers Without Mr. or Mrs. (NOT LIKE)
A genealogy team is curating profiles for passengers without the standard Mr./Mrs. honorifics — typically children, professionals with a Dr./Master./Miss. title, or unmarked names.
Find passengers whose name does not contain 'Mr.' AND does not contain 'Mrs.'. Show name, sex, age. Order by name. Limit to 20 rows.
NOT LIKE '%Mr.%' excludes any name with Mr. anywhere in it. Combining two NOT LIKE conditions with AND is how you stack exclusion filters. (Note: this will also exclude Mr. substring matches inside other words — fine for this dataset, but worth knowing.)
Solve it in the browser editor →
Runs on SQLite in your browser, graded against the expected result, no signup. A wrong answer gets a diagnosis, not just "incorrect".
Schema
passengers
| passenger_id | survived | pclass | name | sex | age | sibsp | parch | fare | embarked |
|---|---|---|---|---|---|---|---|---|---|
| 1 | 0 | 3 | Braund, Mr. Owen Harris | male | 22 | 1 | 0 | 7.25 | S |
| 2 | 1 | 1 | Cumings, Mrs. John Bradley | female | 38 | 1 | 0 | 71.28 | C |
| 3 | 1 | 3 | Heikkinen, Miss. Laina | female | 26 | 0 | 0 | 7.93 | S |
Expected output: Only 'Bonnell, Miss. Elizabeth' appears
Hint
Concepts
SELECT WHERE NOT LIKE
Practise the topic: SQL practice questions
Related questions
Where would this cost you points in an interview?
Ten questions, no signup: a Skillmap across nine SQL skills and the one to fix first.
Take the readiness test