Hello, I have about 3 or 4 collections in a mongodb database. these are basically airbnb json strings that you get when you browser their listings. you can get the json to inspect by using chrome and recording the session in inspector.
I need someone to write one query from all the collections I have (will provide connection string for you to connect).
query - Average Daily Rate - get all listings in listings collections group by zipcode and bedrooms, and then go to calendar collection, match the listing id, take the rate of all days and average them. the fields on the resulting json should be as follows:
zipcode, date, avg daily rate, bedrooms .
I dont want to waste your time as well as my time. so unless you can do this please do not bid for the sake of bidding. Price is flexible as long as you can deliver it.