when you order by two columns use this.imp

 

SELECT *

FROM dbo.tbl_WorkFlowMembers w

WHERE w.WorkFlow_ID IN (

    SELECT WorkFlow_ID

    FROM dbo.tbl_WorkFlow

    WHERE country_code = 'BE'

)

ORDER BY 

    w.WorkFlow_ID,

    w.Approver_Sequence DESC;