diff options
Diffstat (limited to 'queries/simon_initial_check')
| -rw-r--r-- | queries/simon_initial_check | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/queries/simon_initial_check b/queries/simon_initial_check new file mode 100644 index 0000000..703a685 --- /dev/null +++ b/queries/simon_initial_check @@ -0,0 +1,16 @@ +SELECT donors.id AS donor_id, + donor_visits.age AS age, + donor_visits.vaccine_resp AS outcome, + # experimental_data.name_formatted AS data_name, + # experimental_data.data AS data, + donor_visits.visit_year AS year +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 |