LISTING 5: Query That Returns Repairs and Minimum Registration Dates, Using Views

SELECT repairno, MIN(regdate) AS min_regdate
FROM VRepairlog AS VR1
WHERE seq = (SELECT MIN(seq)
             FROM VRepairlog AS VR2
             WHERE VR2.repairno = VR1.repairno)
GROUP BY repairno