SQL : How to convert this SQL query to LINQ or Lambda expression?

Published --