SELECT FName , LName , Sex FROM Patient  WHERE PatientID ='105'




SELECT DFName , DLName, DSpecialty, VisitDate , VisitComent 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