Change query to WP_query in wordpress

See more:

MySQL

WordPress

I want to sort post by different fields. If date is not pass percent not important and just date is important but if date passed I wanna sort by percent. How I can do this with

WP_Query

The bare query I want use is this:

select *, end_date < now() as flag from posts
order by flag
, case when flag = 0 then end_date end desc
, case when flag = 1 then project_percent end desc;

What I have tried:

In other word, I want to use this query with WP_Query.