How do I write a SQL query string to do the following:
pid = 100; (The patient’s pid)
PID ICD-10 ICD-10 DESCR ACTIVE? START END
100 I10 Essential Hypertension. Yes 02/17/1985 -
100 E78.5 Hyperlipidemia, unspecified. No 05/31/2020 6/30/2021
(etc. for all the patient's diagnoses)