Find patients who have

a diagnosis of Acute MI documented

at any time in their history and they have a medication with a dose greater than 500

mg and a medication that is taken once a day documented during

the same instance.

There are 3 patients who have had

• A medication with a dose of 500 mg

• and 
• AND a frequency of once a day entered as a fact in the observation_fact table

• Where the medication dose and frequency have

• the same

•  encounter_

• num ,

•  concept_cd,

•  provider_id,

•  start_date,

•  AND instance_num

• AND the diagnosis of acute MI

• AND the medication dose and frequency all have

• the same

•  patient_num