diff options
Diffstat (limited to 'queries/donors_outcome_across_years')
| -rw-r--r-- | queries/donors_outcome_across_years | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/queries/donors_outcome_across_years b/queries/donors_outcome_across_years new file mode 100644 index 0000000..1cbf55f --- /dev/null +++ b/queries/donors_outcome_across_years @@ -0,0 +1,18 @@ +SELECT donors.id AS donor_id, + donor_visits.age AS age, + donor_visits.vaccine_resp AS outcome, + donor_visits.visit_id AS visit, + donor_visits.visit_day AS day, + donor_visits.visit_year AS year + # experimental_data.name_formatted AS data_name, + # experimental_data.data AS data, +FROM donors + LEFT JOIN donor_visits + ON donors.id = donor_visits.donor_id + # AND donor_visits.visit_id = 1 + # INNER JOIN experimental_data + # ON donor_visits.id = experimental_data.donor_visits_id + # AND experimental_data.donor_id = donor_visits.donor_id +WHERE donors.gender IS NOT NULL + AND donor_visits.vaccine = 4 +ORDER BY donors.id DESC |