A healthcare organization needs an app to track patient encounters, patient lab orders, and patient medications.
✑ Encounters, lab orders, and medication data are maintained in three separate tables linked by PatientID
✑ PatientID values in all three tables are completely accurate
✑ Patients may have encounters without lab orders or medications
The data architect needs to make sure that the count of patient lab orders is correct.
Which method should the data architect to meet this requirement?