How to convert SQL to LinQ

Question

Dear all,

 

Please help me to convert sql to linq.

 

Please see my attachment 

 

Thanks