SQLite 3.27

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE tablename (`col1` INTEGER, `col2` VARCHAR(12), `col3` INTEGER, `col4` VARCHAR(6), `col5` VARCHAR(11));
✓
INSERT INTO tablename (`col1`, `col2`, `col3`, `col4`, `col5`) VALUES
  ('15', 'flex', '2', 'low', 'Not started'),
  ('16', 'flex', '1', 'medium', 'Not started'),
  ('17', 'flex', '2', 'medium', 'Not started'),
  ('18', 'gridonly-med', '1', 'low', 'Not started'),
  ('19', 'gridonly-med', '2', 'low', 'Not started'),
  ('20', 'gridonly-med', '4', 'low', 'Not started'),
  ('21', 'gridonly-med', '1', 'medium', 'Not started'),
  ('22', 'gridonly-med', '2', 'medium', 'Not started'),
  ('23', 'gridonly-med', '4', 'medium', 'Not started');
✓
SELECT *
FROM tablename
ORDER BY col2, col4, col3 DESC


col1
col2
col3
col4
col5


15
flex
2
low
Not started

17
flex
2
medium
Not started

16
flex
1
medium
Not started

20
gridonly-med
4
low
Not started

19
gridonly-med
2
low
Not started

18
gridonly-med
1
low
Not started

23
gridonly-med
4
medium
Not started

22
gridonly-med
2
medium
Not started

21
gridonly-med
1
medium
Not started


SELECT *
FROM tablename
ORDER BY col2 = 'flex' DESC, 
         col4 = 'low' DESC, 
         col3 DESC


col1
col2
col3
col4
col5


15
flex
2
low
Not started

17
flex
2
medium
Not started

16
flex
1
medium
Not started

20
gridonly-med
4
low
Not started

19
gridonly-med
2
low
Not started

18
gridonly-med
1
low
Not started

23
gridonly-med
4
medium
Not started

22
gridonly-med
2
medium
Not started

21
gridonly-med
1
medium
Not started


SELECT *
FROM tablename
ORDER BY CASE col2 WHEN 'flex' THEN 1 ELSE 2 END, 
         CASE col4 WHEN 'low' THEN 1 ELSE 2 END, 
         col3 DESC


col1
col2
col3
col4
col5


15
flex
2
low
Not started

17
flex
2
medium
Not started

16
flex
1
medium
Not started

20
gridonly-med
4
low
Not started

19
gridonly-med
2
low
Not started

18
gridonly-med
1
low
Not started

23
gridonly-med
4
medium
Not started

22
gridonly-med
2
medium
Not started

21
gridonly-med
1
medium
Not started

col1	col2	col3	col4	col5
15	flex	2	low	Not started
17	flex	2	medium	Not started
16	flex	1	medium	Not started
20	gridonly-med	4	low	Not started
19	gridonly-med	2	low	Not started
18	gridonly-med	1	low	Not started
23	gridonly-med	4	medium	Not started
22	gridonly-med	2	medium	Not started
21	gridonly-med	1	medium	Not started