Solution:
SELECT S.STYR_Student_ID, S.StartDate, E.EndDate, S.FirstYear, E.LastYear
SELECT S.STYR_Student_ID, S.StartDate, E.EndDate, S.FirstYear, E.LastYear
From
(SELECT
STYR_Student_ID,
MIN(STYR_Enrolled_On) AS StartDate, MIN(STYR_Year) AS FirstYear
FROM
NG.dbo.STYRstudentYR
GROUP BY
STYR_Student_ID) AS S
INNER JOIN
(SELECT
STYR_Student_ID,
MAX(STYR_Drop_Out_Date) AS EndDate, MAX(STYR_Year) AS LastYear
FROM
NG.dbo.STYRstudentYR
GROUP BY
STYR_Student_ID) AS E
ON S.STYR_Student_ID = E.STYR_Student_ID
ORDER BY S.STYR_Student_ID
No comments:
Post a Comment