/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 vote196 views1 answer
Flask sqlalchemy update row
SQL
0 vote223 views1 answer
Postgres clear table
SQL
0 vote195 views1 answer
Data structures in sql
SQL
0 vote270 views1 answer
Order by number of character in sql
SQL
0 vote245 views1 answer
How to drop a trigger in postgresql
SQL
19 votes246 views5 answers
Display table in sql
SQL
1 vote192 views1 answer
Copy postgres table from one schema into another
SQL
0 vote255 views1 answer
Execute a stored procedure in another stored procedure in SQL server
SQL
0 vote206 views1 answer
Turnicate in mysql
SQL
57 votes2.3K views5 answers
How to create a new user in postgresql
SQL