How to I order by a sql table multiple times?

Question

I don't think I worded it correctly but how do I use order by to sort a table multiple times by a different dimension. For example if I wanted to sort by type of priority of deadlines first (soft, hard, late) then if two inputs have the same priority type, I sort by the duration of the task, then by another parameter, how do I go about doing that?

Answer 1

Use

FROM table_name
ORDER BY column1, column2, ... ASC|DESC;

You automatically order by the other columns mentioned right after your primary ORDER BY column(column1).