Example of DISTINCT does not work

https://mariadb.com/kb/en/getting-data-from-mariadb/ is an introductory tutorial. In it is an example of using "DISTINCT" in a query but the example does not seem to actually work (multiple hits for "Crime & Punishment" are shown instead of just one as the article indicates should result).

The query in question is

SELECT DISTINCT isbn, title

FROM books

JOIN authors USING (author_id)

WHERE name_last = 'Dostoevsky'

ORDER BY title;

Attached is a script which creates the data from the examples and runs the query .