I have an excel report to do with data from quality center.
Some thing that looks like:
Column 1: Total test cases executed to date
Column 2: Total test cases passed to date
Column 3: Total test cases failed to date
Column 4: Total of test cases executed in current week
Column 5: Total of test cases passed in current week
Column 6: Total of test cases failed in current week
Can someone please help me with an SQL query to generate this report (project level)?