diff options
Diffstat (limited to 'queries/donor_demo')
| -rw-r--r-- | queries/donor_demo | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/queries/donor_demo b/queries/donor_demo new file mode 100644 index 0000000..dd5077a --- /dev/null +++ b/queries/donor_demo @@ -0,0 +1,11 @@ +SELECT donors.id as Donor, + donors.gender as Gender, + donor_visits.age_round as Age, + donors.race as Ethnicity, + donor_visits.cmv_status as 'CMV status', + donor_visits.vaccine_resp as Response +from donors + LEFT JOIN donor_visits + ON donors.id = donor_visits.donor_id + AND donor_visits.visit_id = 1 +where donor_visits.vaccine_resp is not null |