The next part of the sentence is what makes it confusing. Although it does make interesting reading, it's harder to read. Please delete "containing each character's high school, their civilian name and the cat who introduced them to their magical crime-fighting destiny."

I think I covered that here - "Return a results table - sailor_senshi, real_name, cat and school" - does it need to be clearer than that?

Looks like it does still rename and pass without AS - so, should I keep the AS requirement because it's best practise, or leave it out because ultimately people might go for succinct solutions and omit stuff they feel is optional...

edit: removed requirement.

Good luck renaming your columns without using AS at all!

what is fixed? I do not see the comment since it is hidden.

Database is randomly generated I have no control over the name generation process so please elaborate.

Good spot, thanks. Fixed.

Thanks for pointing this out. I fixed it.

I've fixed these issues. Would you like to try again to make sure that everything is fixed?

Agreed.

Thanks. You're right it would benefit from random data entry which I know how to do I think in the preloaded area. However, to tell you the truth I haven't been able to work with variables in postgresql properly. I use MS SQL but I've been able to adapt most stuff to postgresql but for some reason whenever I try to use a variable in here it gives me grief.

For instance I wasn't going to have the sales reps capped at 3 but I went to store the count to a variable to mod the rank by the count and it didn't like it. I'll definitely look more into the random data entry mode though.

Thanks for the suggestion!