Lighthouse, The

Problem

So that "The Lighthouse" turns up under L, the book's card in the catalog doesn't say "The Lighthouse." It says "Lighthouse, The": the article at the front moves to the end, after a comma and a space. Without that, half the card catalog would live under T and under A.

Three articles move: The, A, and An. They move only when one of them is the title's first word, the whole word. A title that doesn't start with one of them stays as it is.

Show each book's card and its year of publication, in that order, sorted alphabetically by card.

What it has to return

This is what comes out with the data in the practice database this challenge uses. The column names don’t count, so name yours however you like: what counts is how many there are and the order they come in. Besides this one, the challenge has hidden tests with other data that are revealed when you submit your solution.

You start with this

SELECT title AS card, published
FROM books
ORDER BY card;