/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 vote242 views1 answer
Alling a function from PL/SQL in a select statement in ORACLE
SQL
0 vote215 views1 answer
Postgres grep entire database
SQL
4 votes216 views1 answer
Sql data types
SQL
6 votes210 views1 answer
Oracle pl sql source
SQL
-1 vote218 views5 answers
Operator in sql
SQL
0 vote207 views1 answer
Mysql multiple primary keys
SQL
0 vote206 views1 answer
Kill slow queries mysql
SQL
0 vote202 views1 answer
[object Object]: BY KimbleOne__DeliveryGroup__c, CreatedDate ^ ERROR at Row:1:Column:142 field 'CreatedDate' can not be grouped in a query call
SQL
1 vote211 views1 answer
Describe table in sql
SQL
0 vote198 views1 answer
How to to get current date and time in sql
SQL