/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

2 votes223 views2 answers
Calculate percentage in sql
SQL
0 vote186 views2 answers
Insert into
SQL
0 vote261 views1 answer
Postgresql cast as year and month from timestamp
SQL
2 votes215 views1 answer
Power query concatenate
SQL
0 vote207 views1 answer
Sqlite3 update select
SQL
16 votes197 views1 answer
CTE statement sql server
SQL
0 vote199 views1 answer
Copy Table from SQL to CSV
SQL
1 vote199 views1 answer
Alter add syntax
SQL
11 votes204 views3 answers
Sql_mode=only_full_group_by
SQL
17 votes192 views6 answers
Mysql import sql file
SQL