/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 vote152 views3 answers
String to int mysql
SQL
0 vote178 views1 answer
Oracle gather table statistics
SQL
1 vote124 views1 answer
Convert money to varchar sql server
SQL
0 vote175 views1 answer
Count the table indatabase
SQL
1 vote219 views1 answer
Oracle create program if not exists
SQL
0 vote171 views1 answer
Mysql identified by syntax error
SQL
0 vote171 views1 answer
Mariadb errno 121
SQL
0 vote415 views1 answer
Create pl/sql stored procedure
SQL
0 vote166 views1 answer
Prepared statement mysql java delete selected rows
SQL
10 votes170 views1 answer
Dba_dependencies
SQL