/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 vote216 views1 answer
Database xml sql
SQL
0 vote234 views1 answer
What is database username and password in mysqliconnect
SQL
1 vote228 views3 answers
Nth highest salary
SQL
0 vote217 views1 answer
Get number of tables in database sql
SQL
9 votes243 views2 answers
SELECT User,Host FROM mysql.user;
SQL
8 votes214 views2 answers
Change name of colum in sql table
SQL
1 vote248 views1 answer
UseSqlServer no definition
SQL
1 vote227 views1 answer
Select tables with name like mysql
SQL
0 vote226 views3 answers
Run sql command line
SQL
2 votes220 views1 answer
Can you use a where clause for a child query
SQL