Shelve the Films Library-Style

Libraries and film catalogues file titles without their leading article: *The Dark Knight* sits under D, *A Beautiful Mind* would sit under B. The catalogue team wants to see how the 100 films in movies spread across the shelves once that rule is applied.

The rule: a title that starts with the word The, A or An — the word, followed by a space — is shelved by what comes after the article. Every other title is shelved by its own first character.

Show exactly these 3 columns, in this order: shelf (the first character of the shelving title, upper-cased), films (how many films sit on that shelf) and moved_by_article (how many of those films are there only because an article was dropped). Order by shelf.

The traps are all in the data:

- American History X, Arrival and Assassin's Creed start with the *letter* A, not the *word* A. A test for titles starting with 'A' files American History X under M.
- Trolls and Tarzan start with T, not with The.
- Resident Evil: The Final Chapter and Star Wars: The Force Awakens contain "The " in the middle. Remove every "The " from a title and both will count as moved — neither is.

Only the start of the title counts, and only a whole word.