/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 vote266 views2 answers
Create new table from existing table with data in sql server
SQL
0 vote142 views1 answer
Compare if is null sql
SQL
1 vote128 views1 answer
Oracle first row
SQL
0 vote154 views1 answer
Sql basic commands
SQL
4 votes143 views4 answers
Pl sql output
SQL
4 votes121 views4 answers
Rollback in sql
SQL
79 votes314 views6 answers
Grepper code
SQL
0 vote145 views1 answer
Liquibase update row
SQL
0 vote137 views1 answer
Where name ends in SQL
SQL
0 vote151 views3 answers
Insert query in ci
SQL