/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 vote140 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL
0 vote130 views1 answer
Select the date 30 days less that the todays date sql request
SQL
1 vote206 views1 answer
How to select the nth row in a SQL database table?
SQL
0 vote160 views2 answers
How to take recent row without limit in mysql
SQL
0 vote137 views1 answer
Plsql check for string in numeric
SQL
-1 vote131 views1 answer
Sql select data from one database and insert into a different database
SQL
11 votes136 views2 answers
Turn off safe mode mysql
SQL
6 votes142 views1 answer
Allsource oracle
SQL
1 vote111 views1 answer
Mysql see column types
SQL
0 vote127 views2 answers
Mysql to python pandas
SQL