$criteria = new CDbCriteria;
.......
$criteria->select = 'user.user_id as userId, user.name as userName, COUNT(*) AS totalCount,
                        SUM(CASE WHEN (t.create_datetime > (SELECT DATE_ADD(curdate(), INTERVAL(2-DAYOFWEEK(curdate())) DAY)) AND t.create_datetime < '2013-06-08') THEN 1 ELSE 0 END) AS weeklyCount,
                        SUM(CASE WHEN (MONTH(t.create_datetime) = 9 ) THEN 1 ELSE 0 END) AS monthlyCount';
.......
$criteria->group = 'user.user_id';
$criteria->with = array('user');
$criteria->addCondition('t.deleted=0', 'AND');
$criteria->addCondition('t.user_id = user.user_id', 'AND');

Type: CDbException
Active record `Inspection` is trying to select an invalid column `SUM(CASE WHEN (t.create_datetime > (SELECT DATE_ADD(curdate()`. Note, the column must exist in the table or be an expression with alias.

$criteria->select = array(
   'user.user_id AS userId',
   'user.name AS userName',
   'COUNT(*) AS totalCount',
   'SUM(CASE WHEN (t.create_datetime > (SELECT DATE_ADD(curdate(), INTERVAL(2-DAYOFWEEK(curdate())) DAY)) AND t.create_datetime < '2013-06-08') THEN 1 ELSE 0 END) AS weeklyCount',
   'SUM(CASE WHEN (MONTH(t.create_datetime) = 9 ) THEN 1 ELSE 0 END) AS monthlyCount'
);