LISTING 4: Query That Returns Repairs and Minimum Registration Dates, Using an Auxiliary Table

SELECT repairno, MIN(regdate) AS min_regdate
FROM Repairlog AS R1 JOIN Statuses AS S1
  ON R1.status = S1.status
WHERE seq = (SELECT MIN(seq)
      FROM Repairlog AS R2 JOIN Statuses AS S2
          ON R2.status = S2.status
      WHERE R2.repairno = R1.repairno)
GROUP BY repairno