/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 vote288 views1 answer
Ms sql print more than 1 variable
SQL
0 vote271 views1 answer
Mysql set column equal to another automatic
SQL
0 vote288 views1 answer
Mariadb datetime change to microseconds
SQL
0 vote265 views1 answer
Replace multiple string in query sql
SQL
0 vote279 views1 answer
Sql select all records from all tables where not empty
SQL
0 vote325 views1 answer
How to add auto increment primary key
SQL
0 vote295 views2 answers
Replace null with 0 in sql
SQL
0 vote274 views1 answer
Power bi union columns
SQL
0 vote280 views1 answer
Oracle list user locked
SQL
1 vote264 views1 answer
Postgres regex remove special characters
SQL