[solved]can not sort query results

Hi. I have a database with a query named “plot_availability_characteristics”.
When I open the query and try to sort it by any of the columns nothing happens. I do not have this issue with any of the other queries in the database.
Here is a short video demonstrating my issue

Here is a link to the database so you can have a look.https://drive.google.com/open?id=177ZMBUI9fzW9vo3h1eAoAEa44WBt8OkU


The problem is that you have changed items from what was originally posted.

The difference is that this latest query used includes an Order By clause. Remove that and the sorting works. With it in place the re-running is just putting it back into the same sequence.

I had no problem with the last sorting because it had no Order By in it but yours may have been modified to the newer query with the sequencing.

Thank you.