Looking to move my fields in a column

I am trying to move my fields in a column so that "Studio" is first. Attached is an image of what it looks like now. I tried to write a query but I keep getting this error message. What am I doing wrong? or am I able to do this?


count is a reserved word (on "as COUNT"), try changing it to "count_something"

Thank you for the help! I just tried that and am still getting the error message

try running the same syntax on an external database client to see where the error is

I am still getting the same error when I try it on PgAdmin Postgresql.

ok so the query is malformed in some way, check out the error in PgAdmin to see the exact line of the error so you can correct it