Properly Capitalized Student Names

Scenario

The new student directory page renders names verbatim from the database. Some legacy records have inconsistent casing (e.g. "DeAndre", "aaliyah"). Use INITCAP to render every person's display name in proper Title Case so the directory looks consistent.

Expected output

One row per person in dbo.ods_person, sorted by id, with display_name = first + space + last in Title Case. Letter case is part of the answer.

Tables

Hints