如何在SQL中按多列排序

我需要帮助排序我的结果,可能需要结合使用case语句。请参阅显示现有输出、条件和所需输出的图像。在Excel中轻松显示,但实际上是在SQL中完成的。ORDERBY子句是我需要帮助的内容。

select 
distinct 
CONCAT(selection.Selid,' - ' ,Selection.Name,' - ', DevOfficer.Description,' - ', SchemeCount.[Number of Schemes],' Schemes - ',case when selection.Project=1 then '[Project] ' when selection.Project=0 then '[Selection] '  else 'Error' end,convert(varchar,selection.lastupdated,103)) [String]
, selection.selid
, selection.lastupdated 
,case when selection.Project=1 then '[Project]'
when selection.Project=0 then '[Selection]'
else 'Error' end
,selection.lastupdated
from selection 
inner join SelScheme on selection.SelID =selscheme.SelID 
inner join DevOfficer on selection.DevOfficer = DevOfficer.DevOfficerID 
inner join (select selscheme.selid ,count(selscheme.SchemeID) [Number of Schemes] from SelScheme group by SelScheme.SelID) SchemeCount on schemecount.SelID = Selection.SelID 
where selection.masterselid = 0 
order by 
--selection.lastupdated  desc,
case 
when selection.Project=1 then '[Project]'
when selection.Project=0 then '[Selection]' 
 else 'Error' End Desc
 ,selid desc
 ,selection.lastupdated