ORDER BY changes the sequence after the filter selects the population. It belongs at the end of the query. A secondary sort makes ties predictable, which matters when people compare a saved report with a handoff list. Priority ordering follows priority rank rather than alphabetical spelling.
Date boundaries deserve the same care. A due date before November 6 differs from a due date on or before November 6. Empty due dates don't become overdue simply because they lack a value. The local model uses ISO date fields and a fixed practice clock. It doesn't emulate every relative-date function or user time-zone setting. These exercises state exact dates so you can isolate inclusion and ordering without relying on the wall clock of the device running the lesson.
Keep filtering, inclusive dates and deterministic ordering distinct.