I have two sub query in my sql ,How can I build it with Yii?
select tmp1.`name`,tmp1.daily_sold_unit,tmp1.daily_sold_area,tmp1.daily_sold_meanprice,,tmp1.total_sold_unit,tmp1.total_sold_area,tmp2.total_unsold_unit,tmp2.total_unsold_area
from
(select id,stat_date,`name`,district,
SUM(daily_sold_unit) AS daily_sold_unit,
SUM(daily_sold_area) AS daily_sold_area,
SUM(daily_sold_amount)/SUM(daily_sold_area) AS daily_sold_meanprice,
MAX(total_sold_unit) AS total_sold_unit,
MAX(total_sold_area) AS total_sold_area
from ne_zz WHERE stat_date BETWEEN '2014-12-01' AND '2014-12-30' AND `name` = 'somenames' GROUP BY `name`
) tmp1,
(select `name`,total_unsold_unit,total_unsold_area from ne_zz where stat_) tmp2
where tmp1.`name`=tmp2.`name`