Our 'born' approximation, and a special laureate

We saw earlier that the laureates collection encodes uncertainty about birthdate in a special way. When a birthdate is unknown, the "born" field has the value "0000-00-00". Thus,

db.laureates.count_documents({"born": "0000-00-00"})

counts the number of such laureates. Or does it?

We also saw that the total number of laureate prizes is more than the number of laureates -- some were awarded more than one prize. There is one in particular with a whopping three prizes, and this laureate holds key information to aid our quest to determine the proportion of prizes awarded to immigrants.

1
- Use a filter document (criteria) to confirm that every document in the laureates collection has a "born" field.
2
- Use a filter document (criteria) to fetch a laureates document with at least three elements in its "prizes" array.

Exercise

Our 'born' approximation, and a special laureate

Instructions 1/2