/SQL/Mysql order by where condition sub query

Mysql order by where condition sub query

SELECT orders.status, orders.created_at
FROM `orders`
ORDER BY
  status='new' DESC,
  status='processing' DESC,
  CASE WHEN status IN ('new', 'processing') THEN created_at END ASC,
  CASE WHEN status NOT IN ('new', 'processing') THEN created_at END DESC

Similar codes

1 vote144 views1 answer
Postgres power
SQL
0 vote127 views2 answers
Database owner can't create new tables postgres
SQL
2 votes115 views1 answer
Sqlplus clear screen
SQL
0 vote125 views1 answer
How to avoid duplicate records in sqlite
SQL
2 votes116 views1 answer
Sql update alias
SQL
1 vote119 views3 answers
How to truncate foreign key constraint table
SQL
0 vote129 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
1 vote137 views1 answer
Sqlalchemy on delete set null
SQL
2 votes129 views2 answers
Mamp connect mysql terminal
SQL
0 vote128 views1 answer
Python connect microsoft sql server
SQL