Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select concat(lookup_hospital.city_code,'/',lookup_hospital.hospital_code) as hospital_code, sum(f_under_1) as f_under_1, sum(f_1_4) as f_1_4, sum(f_5_9) as f_5_9, sum(f_10_14) as f_10_14, sum(f_15_17) as f_15_17, sum(f_18_25) as f_18_25, sum(f_25) as f_25,
- sum(m_under_1) as m_under_1, sum(m_1_4) as m_1_4, sum(m_5_9) as m_5_9, sum(m_10_14) as m_10_14, sum(m_15_17) as m_15_17, sum(m_18_25) as m_18_25, sum(m_25) as m_25
- from tracking_familymember
- left join club_patient on club_patient.id_patient = tracking_familymember.id_patient
- left join club on club_patient.id_club = club.id
- left join lookup_hospital on lookup_hospital.id = club.id_hospital
- group by club.id_hospital
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement