INNER JOIN Student s
ON P.NRecordBook=S.NRecordBook
GROUP BY P.NrecordBook,SName,IDGroup) a
INNER JOIN
(SELECT IDGroup,AVG(Mark) Bmark
FROM Progress P
INNER JOIN Student s
on P.NRecordBook=S.NRecordBook
Сейчас читают про:
8269
7969
2015-07-04
256INNER JOIN Student s
ON P.NRecordBook=S.NRecordBook
GROUP BY P.NrecordBook,SName,IDGroup) a
INNER JOIN
(SELECT IDGroup,AVG(Mark) Bmark
FROM Progress P
INNER JOIN Student s
on P.NRecordBook=S.NRecordBook
|
|
8269 7969