Why do I get the error that I am missing a parentheses when I try to include an ORDER BY when I am creating a table?
That’s hard to see without seeing the SQL that you are trying to execute, but in general, the only way you can include an ORDER BY in a create table statement, is when you say:
create table table_name as
select columns
from some_other_table
order by columns
If you are just making a create table statement on its own, ORDER BY does not apply.