Chapter 4 Exercise 56

56. List any patients who were older than 60 and had a systolic pressure below 120 (but not zero).

SELECT Patient.PatientID, Patient.LastName, Visit.Systolic,
DateDiff("yyyy",[DateOfBirth],[VisitDate]) AS VisitAge
FROM Patient INNER JOIN Visit ON Patient.PatientID = Visit.PatientID
WHERE (((Visit.Systolic) Between 1 And 119)
AND ((DateDiff("yyyy",[DateOfBirth],[VisitDate]))>60));