How should I practice Null-Safe Full Name?

Start by reading the full statement, solve the visible examples, then compare the pattern against related infosys onsite interview problems in FastPrep.

Is Null-Safe Full Name associated with infosys?

FastPrep tags this as a infosys onsite interview coding practice problem when the problem catalog has that company and stage context.

Problem · Database

Null-Safe Full Name

● Easy

infosysNEW GRADONSITE INTERVIEW

Problem statement

The table people contains one row per person. Return person_id and a full_name made from first_name, middle_name, and last_name.

Skip every NULL name part and join the remaining parts with exactly one ASCII space. Return every person in ascending person_id order.

Table schema

MySQLPostgreSQLPandas

Use the same input data with any supported language. Open the Schema tab in the editor to see the generated SQL setup or Pandas DataFrames.

people

One row per person.

Column	Type	Nullable	Description
person_idPK	Integer	No	—
first_name	Text	No	—
middle_name	Text	Yes	—
last_name	Text	Yes	—

Expected result

Your query or function must return these columns.

Column	Type	Nullable	Description
person_id	Integer	No	—
full_name	Text	No	—

Row order: must match exactly. Numeric tolerance: 0.

Constraints

1 <= people.length <= 200000
person_id is unique.
first_name is non-NULL.
Every non-NULL name part is non-empty, contains at most 100 characters, and has no leading or trailing whitespace.