conversion rate for registration in AAQ

gistfile1.txt

SELECT active_users.user_date as user_date, active_users.active_users, all_users.all_users, (active_users.active_users/all_users.all_users)*100 as conversion_rate
FROM
(
SELECT DATE(`questions_question`.`created`) as user_date, count(*) as active_users
FROM `auth_user`
JOIN `questions_question` ON `questions_question`.`creator_id`=`auth_user`.`id`
Where `auth_user`.`is_active`='1'
AND DATE(`questions_question`.`created`) LIKE '2012-07-01'
AND DATE(`auth_user`.`date_joined`) LIKE '2012-07-01'
group by DATE(`questions_question`.`created`)
) as active_users
JOIN
(
SELECT DATE(`questions_question`.`created`) as user_date, count(*) as all_users
FROM `auth_user`
JOIN `questions_question` ON `questions_question`.`creator_id`=`auth_user`.`id`
WHERE
DATE(`questions_question`.`created`) LIKE '2012-07-01'
AND DATE(`auth_user`.`date_joined`) LIKE '2012-07-01'
group by DATE(`questions_question`.`created`)
) as all_users
ON active_users.user_date=all_users.user_date