/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 vote327 views1 answer
Sql server split string and insert into table select
SQL
21 votes331 views3 answers
Sql average
SQL
0 vote345 views1 answer
Copy value from one column to another postgres
SQL
0 vote315 views1 answer
Automate mysql cli query
SQL
0 vote347 views1 answer
Get null value in sql
SQL
-1 vote322 views1 answer
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.8.0.
SQL
1 vote338 views1 answer
Cannot insert explicit value for identity column in table 'Tbl_Increment_File' when IDENTITY_INSERT is set to OFF.
SQL
0 vote331 views1 answer
Display first three characters sql
SQL
0 vote360 views1 answer
Mysql db dump restore max file size issue
SQL
0 vote348 views2 answers
Oracle sql for each row
SQL