|
|
От: | glut | |
| Дата: | 11.11.02 16:48 | ||
| Оценка: | |||
SELECT DatePart(yy,ExamDate), SUM(TotalExamsThisYear), SUM(TotalExamsThisYearOfTypeX)
FROM
(SELECT ExamDate, COUNT(*) as TotalExamsThisYear,
(SELECT COUNT(*) as TotalExamsThisYearOfTypeX
FROM Exams WHERE Exams.ExamDate=e.ExamsDate AND Exams.ExamType=X)
FROM Exams) AS Totals
GROUP BY DatePart(yy,ExamDate)