I had no problems with the tasks up to this point. I saw several other topics addressing this Lab, but none seems to relate to the most recent status of the
The Question is:
How many inspections from the
sample_training.inspections collection were conducted in the city of
my current attemps (2/3):
- my first guess was to match the nested document’s field for
"NEW YORK"which returned
18280which was a wrong anwer.
- then I thought, maybe some are spelled differently and did a
"[Nn][Ee][Ww] [Yy][Oo][Rr][Kk]"which brought up 5 cities with
"New York"and another 24 with
"WEST NEW YORK". I am not from the US but googled up that West New York is a different town. So adding a query to remove
"WEST NEW YORK"gave me
18285which was wrong as well.
I am now stuck at my 3rd attempt and have no further idea how to narrow this down. Going for the
zips seems incorrect, as already some
"NEW YORK" cities have different zips. In addition older topics from end 2020 seem to get
"NEW YORK" (1 less) and 5
"New York" which would sum up to
May anybody point me towards the solution, please?