使用Qt中的SQL对表元素进行非常规的排序。

I'm creating a ticketing system and I want to populate a table for people to view all of the open tickets. I want them to be sorted by priority, from critical --> high --> medium --> low. I'm creating a ticketing system and I want to p