search

adriangohjw / bc2402-designing-developing-databases

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

nosql q5 is wrong #10

Closed oshwad closed 2 years ago

oshwad commented 2 years ago

i think the answer is wrong... must display the first date each vaccine was administered, then compute the difference between the earliest and lastest date identified above.

it should be exactly the same as indiv assignment

adriangohjw commented 2 years ago 
// q5: Italy has commenced administrating various vaccines to its populations as a vaccine becomes available.
// Identify the first dates of each vaccine being administrated, 
// then compute the difference in days between the earliest date and the 4th date.
// [source table: country_vaccinations_by_manufacturer]

not quite getting what you mean since this is the answer (difference in days between the earliest date and the 4th date)

image

adriangohjw commented 2 years ago

IMO there is no need to display the first date since it felt like the question is just stating the approach. Nevertheless, I have made the changes in https://github.com/adriangohjw/bc2402-designing-developing-databases/pull/13 and if you still think there's a need, you can merge the PR in