--
-- Since : 5.8.0
--
-- File    : whathappened.sql
-- Purpose : this file contains the needed SQL commands to 
--           retreive pilot jobs from DB
-- Usage   : mysql < whathappened.sql
--


       select date(completeddate),count(*) 
         from works 
	 where not isnull(completeddate)
	   and date(completeddate)>"2009-07-14" 
	   and status="COMPLETED" 
	 group by date(completeddate);

