Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- obs.value_text as 'Diagnosis',
- count(obs.person_id) as 'Number of Patients',
- person.gender,
- person.birthdate,
- TIMESTAMPDIFF(YEAR, person.birthdate, CURDATE()) AS age
- FROM openmrs.obs
- inner join openmrs.person on obs.person_id = person.person_id
- where obs.concept_id='159393' and obs.voided=0 and person.voided=0
- group by obs.value_text;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement