/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 vote190 views1 answer
Error Code: 1140. In aggregated query without GROUP BY, expression #3 of SELECT list contains nonaggregated column 'grepper_history.search_history.term'; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote177 views1 answer
List MySQL Table and Index Size
SQL
0 vote243 views1 answer
Oracle temporary table
SQL
0 vote221 views1 answer
Mysql where in maintain order
SQL
0 vote196 views1 answer
On sql table data exists
SQL
0 vote179 views2 answers
Clear window pl sql
SQL
2 votes257 views1 answer
Mysql now format
SQL
0 vote233 views1 answer
Automated psql csv export script on windows
SQL
0 vote236 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL
5 votes184 views2 answers
Sql number columns
SQL