search

adriangohjw / bc2402-designing-developing-databases

Designing & Developing Databases (BC2402)
0 stars 0 forks source link

sql qn 9 output is abit weird #15

Closed deionna closed 2 years ago

deionna commented 2 years ago

https://github.com/adriangohjw/bc2402-designing-developing-databases/blob/87342634e5366ab28c6df4cea29fe848669a16a8/relational-updated.sql#L65-L97

i think shouldnt join on the vaccine but instead join on the dates? like for each day in first_vaccine_date, there should be 4 records (number of vaccinations for each type of vaccine respectively for 20, 30 and 40 days after the first date) + should show the new cases for each day in first_vaccine_day as well.

adriangohjw commented 2 years ago

the output is based on my interpretation. will change if majority think its wrong @oshwad @ihsunday 

-- 9) Vaccination Drivers. Specific to Germany, based on each daily new case, 
-- display the total vaccinations of each available vaccines after 20 days, 30 days, and 40 days.
adriangohjw commented 2 years ago

duplicated with https://github.com/adriangohjw/bc2402-designing-developing-databases/issues/6