/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

0 vote114 views1 answer
Modifier une valeur sql
SQL
0 vote119 views1 answer
Neo4j command to run script file
SQL
0 vote111 views1 answer
Sql tabelle erstellen
SQL
0 vote147 views1 answer
Run docker container with database as rds metabase
SQL
0 vote120 views2 answers
How covert into int in maria db
SQL
4 votes114 views2 answers
Tables in sql
SQL
0 vote118 views2 answers
How to count codition
SQL
0 vote114 views1 answer
Oracle get running queries
SQL
61 votes274 views6 answers
Mysql add column
SQL
0 vote102 views1 answer
Sql change primary key to composite key
SQL