Wer ist Patient von Arzt Jschke?

select pa.* from patient pa
left join praxis_patient pp on (pp.patient_id = pa.id)
left join praxis on (pp.praxis_id = praxis.id)
left join arzt on (arzt.praxis_id = praxis.id)
where arzt.name='Jschke';


Wieviel Privatpatienten hat Gemeinschaftspraxis Jschke?

select count(pa.id) as anzahl from praxis
left join praxis_patient pp on (pp.praxis_id = praxis.id)
left join patient pa on (pp.patient_id = pa.id)
left join krankenkasse kk on(pa.krankenkasse_id = kk.id)
where praxis.name='Gemeinschaftspraxis Jschke' and kk.privat='Y'


Wann wurde Patient Hahn zuletzt behandelt?

select MAX(bh.von) from patient
left join behandlung bh on(bh.patient_id = patient.id)
where patient.name='Hahn'


Wieviel Praxen besucht Patient Naumann?

select count(praxis.id) as anzahl from praxis
left join praxis_patient pp on (pp.praxis_id = praxis.id)
left join patient pa on (pp.patient_id = pa.id)
where pa.name='Naumann'

Welcher Patient besucht eine Praxis ausserhalb seines eigenen Wohnortes?

select pa.name from patient pa
left join praxis_patient pp on (pp.patient_id = pa.id)
left join praxis on (pp.praxis_id = praxis.id)
where pa.ort != praxis.ort



