SELECT COUNT(*),B.cause, discribe FROM failed A, cause B WHERE starttime>='2003-04-09' and stoptime<'2003-04-12'.............GROUP BY B.cause, discribe
SELECT COUNT(*),B.cause, discribe FROM failed A, cause B WHERE starttime>='2003-04-09' and stoptime<'2003-04-12' and a.cause=b.cause .............GROUP BY B.cause, discribe
SELECT a.cause, b.discribe,COUNT(*) FROM failed a, cause a WHERE a.starttime>='2003-04-09' and a.stoptime<'2003-04-12' and b.cause=a.cause ............. GROUP BY a.cause, b.discribe
WHERE a.starttime>='2003-04-09' and a.stoptime<'2003-04-12' and b.cause=a.cause .............
GROUP BY a.cause, b.discribe