Just curious, what's the drawback of using a bog standard join using tables? (posting a wild guess at such a query :w00t:)

SELECT grads.student_ID, grads.Lname, WAGES.SumWage, WAGES.SumHours

FROM GRADS

JOIN

(

SELECT year, quarter, ssn, hours, industry

, ROW_NUMBER() over (partition by year, quarter, ssn ORDER BY wages ASC) rn

, SUM(wages) over (partition by year, quarter, ssn ) SumWage

, SUM(hours) over (partition by year, quarter, ssn ) SumHours

FROM dbo.Wage_data

) WAGES

ON GRADS.ssn = WAGES.ssn

where WAGES.rn = 1