/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

7 votes142 views1 answer
Alter table add key sql
SQL
0 vote168 views1 answer
Oracle list proxy users
SQL
0 vote178 views1 answer
How to add timestamp column in mysql
SQL
0 vote171 views1 answer
Datetime postgres typeorm
SQL
0 vote174 views1 answer
ORA-13717
SQL
2 votes182 views1 answer
Postgresql create table as select
SQL
0 vote158 views1 answer
Drop all tables in azure sql database
SQL
1 vote177 views1 answer
Error code 1292 mysql workbench
SQL
1 vote210 views1 answer
Key validation sql
SQL
0 vote133 views2 answers
Jupyter notebook connect to database
SQL