Yes, you are right. But the kata description is not wrong, when it was designed the generated data worked that way. Someone changed the functions that generates the names to add those titles. Still, this makes this kata even closer to the real world problems we face on a day to day base. The solution should be more complex than I've originally envisioned though.

Make sure to do a SELECT from the VIEW itself.

I make the Select query is already okay, but when add CREATE VIEW, no row is return, do you have any idea ?