SELECT FName , LName ,Birthdate, Sex FROM Patient  WHERE PatientID ='105'
SELECT DFName , DLName, DSpecialty, VisitDate , VisitComment FROM Doctor JOIN Visit ON Visit.DoctorID = Doctor.DoctorID WHERE Visit.PatientID ='105' ORDER BY Visit.VisitDate
SELECT Prescription.PrescDate, PrescriptionDetail.PrescEndDate ,
PrescriptionDetail.PrescIndications ,PrescriptionDetail.Dosage , Medicine.GenericMedName ,
Medicine.Dosage, Visit.VisitDate FROM Visit JOIN Prescription ON Visit.PrescriptionID = Prescription.PrescriptionID
 JOIN PrescriptionDetail ON  PrescriptionDetail.PrescriptionID = Prescription.PrescriptionID
 JOIN Medicine ON PrescriptionDetail.MedicineID = Medicine.MedicineID
 WHERE Visit.PatientID = '105' ORDER BY Visit.VisitDate
 SELECT LabName, LabExamName,TestDate,TestResult,Units,TestIndicator,DFName,DLName,DSpecialty
 FROM  LabTest JOIN LabTestResult ON LabTest.LabTestID = LabTestResult.LabTestID
  JOIN Doctor ON LabTest.DoctorID = Doctor.DoctorID
 JOIN TestType ON LabTestResult.TestTypeID = TestType.TestTypeID WHERE LabTest.PatientID= '105' ORDER BY TestDate