/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

1 vote223 views1 answer
T-SQL Alter the column data type
SQL
0 vote201 views3 answers
How to run sql query
SQL
0 vote189 views1 answer
Postgresql create user roles
SQL
13 votes208 views3 answers
Change data type postgresql
SQL
0 vote191 views1 answer
Sum value by month sql
SQL
3 votes258 views2 answers
Find string in stored procedure sql server
SQL
8 votes206 views1 answer
Mysql limit rows
SQL
1 vote200 views2 answers
Update with inner join sql server
SQL
1 vote236 views1 answer
Ora-01109 database not open in oracle 19c
SQL
0 vote187 views1 answer
Cannot truncate a table referenced in a foreign key constraint (`video_clips`.`channel_clips`, CONSTRAINT `clips_fk` FOREIGN KEY (`clip_id`) REFERENCES `video_clips`.`clips` (`id`)) in sql]
SQL