Need for Complex Sort Criteria Views
You are able to create a single block or page in views with different sort criteria using attachments in views

 


So create a view with some criteria and add an attachment like above and override the sort criteria as you need
Then add your attachment to your page or block as below


 

Here is a post which explains this in detail.