SQL Quest › SQL Interview Questions › String Functions

Long-Named Passengers

EasyFreeQuerying BasicsString Functions

The memorial plaque engraver needs to size name plates. Find passengers whose name is longer than 30 characters. Show name, name_length (the character count of the name), and pclass. Sort by name_length descending, with name ascending as a tie-breaker.

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	fare	embarked
1	0	3	Braund, Mr. Owen Harris	male	22	1	7.25	S
2	1	1	Cumings, Mrs. John Bradley	female	38	1	71.28	C
3	1	3	Heikkinen, Miss. Laina	female	26	0	7.93	S

Expected output: Names > 30 chars, longest first

Hint

LENGTH(name) returns character count in SQLite. Use it in both WHERE (LENGTH(name) > 30) and SELECT (LENGTH(name) AS name_length). Alias the computed column so ORDER BY can reference it.

Concepts

SELECT String Functions LENGTH WHERE ORDER BY

Practise the topic: SQL practice questions · String function practice

In these company practice sets

Google · Snowflake

A SQL Quest challenge matched to patterns reported for these companies — not a question any of them has published.

Long-Named Passengers

Schema

Hint

Concepts

In these company practice sets

Related questions