/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 vote354 views1 answer
If exist column in table drop sql query mysql
SQL
150 votes643 views10 answers
Grepper
SQL
15 votes353 views6 answers
Psql
SQL
4 votes352 views1 answer
Delete record mysql query
SQL
0 vote390 views1 answer
Mysql extract day from date leading zero
SQL
15 votes390 views6 answers
Laravel db transaction
SQL
0 vote372 views1 answer
Sql tablo hangi sp de
SQL
0 vote353 views2 answers
Oracle create chain rule
SQL
0 vote388 views1 answer
Select place default lat long
SQL
0 vote369 views1 answer
Sql server udf performance
SQL