php - Doctrine2 from subqueries -

I need to convert the following code into theory, but it does not seem right that the principle theory 2 function. (SELECT ProductName, DATEDIFF (Week, '2015-05-30', Date) AS Week Number, Select Sales from Table) ProductName, WeekNumber

  ProductName, Week Number, Zodiac (Sales)   
 Thanks   
 
 
 Principle 2 ORM  FROM < Permissions for a subquery / code> section are only  WHERE  and  HAVING  sections that are supported by various RDBMS vendors.  
 Please complete DQL