alcides · May 31, 2009 00:37
diff --git a/query.sql b/query.sql
 SELECT tasks_after_deadline, tasks_open, tasks_after_deadline/tasks_open as ratio
 FROM (
 SELECT COUNT( * ) as tasks_after_deadline
 FROM  `gestor_actionitem` 
 WHERE  `due_date` < NOW( ) 
 AND  `done` =0
 LIMIT 0 , 30
 )tab, (
 SELECT COUNT( * ) as tasks_open
 FROM  `gestor_actionitem` 
 WHERE `done` =0
 LIMIT 0 , 30
 )tab2
diff --git a/results.txt b/results.txt
 tasks_after_deadline	tasks_open	ratio
 29	42	0.6905
	SELECT tasks_after_deadline, tasks_open, tasks_after_deadline/tasks_open as ratio
	FROM (
	SELECT COUNT( * ) as tasks_after_deadline
	FROM `gestor_actionitem`
	WHERE `due_date` < NOW( )
	AND `done` =0
	LIMIT 0 , 30
	)tab, (
	SELECT COUNT( * ) as tasks_open
	FROM `gestor_actionitem`
	WHERE `done` =0
	LIMIT 0 , 30
	)tab2