/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 vote175 views1 answer
Create a PostgreSQL user django on mac
SQL
0 vote168 views1 answer
Sql check for null and empty string
SQL
1 vote167 views1 answer
Select statement to print longest name
SQL
0 vote157 views1 answer
Mariadb set vertical output format
SQL
1 vote179 views1 answer
Mysql last year
SQL
0 vote160 views1 answer
Prepared statement mysql java delete selected rows
SQL
0 vote199 views1 answer
Alter owner in PostgreSQL
SQL
0 vote219 views1 answer
Google sheets data validation custom formula filter
SQL
3 votes131 views1 answer
Ubuntu install postgresql 12
SQL
1 vote206 views2 answers
How to add amount between date in sql
SQL