154
  1. millerrenee
  2. 82
  3. 1488
  4. 5
  5. 142
  7. Howard St & Centre St and 5 Ave & E 78 St
156
  1. Millerrenee
  2. 82
  3. 1746
  4. 5
  5. 142
  6. 853
  7. E 21 at &3 Ave , Howard St. & Centre St.
  8. 2338
  9. 1436
  10. 6346
157
  1. db.customers.findOne({email:“nicoleanderson@hotmail.com”}).username

Ans 1. ‘‘millerrenee’

  1. db.movies.findOne({title:“The Kid Brother”}).runtime

Ans 2. 82

  1. db.transactions.findOne({account_id:{“$gt”:183500, “$lt”:184000}}).transaction_count

Ans 3. 94

  1. db.sales.aggregate([{$match:{customer, email:“kave@we.com”}}])

Ans 4. ???

  1. db.posts.countDocuments({title:“Bill of Rights”})

Ans 5. 142

  1. db.zips.findOne({city:“CLEVELAND”}).loc

Ans 6. { y: 33.992106, x: 86.559355 }

  2. db.restaurants.countDocuments({“borough”: “Bronx”})

Ans 8. 2338

158

username: ‘millerrenee’,
2.
runtime: 82;
3.
1488
4.
satisfaction: 5.
5.
142
6.
853
7.
Howard St & Centre St and 5 Ave & E 78 St
8.
2338
9.
0
10.
6346.

160
  1. Millerrenee
  2. 82
  3. 1746
    1. the customer satisfaction is 5
  5. 142
  6. 853
  7. W56ST and 4Ave st and 8ave
  8. 2338
  9. 1436
    10.6346
161

  1. millerrenee

  2. 82

  3. 1746

  4. 5

  5. 142

  6. 853

  7. ‘York St & Jay St’ & ‘York St & Jay St’

  8. 2338

  9. 0

  10. 6346

162
  1. millerrenee
  2. 82
  3. 1746
  4. 765
  5. 142
  6. 853
  7. 5978
  8. 2338
  9. 0
  10. 6346
163

1.millerrenee
2.83 mins
3.1746
4.5
5.142
6.853
7.E 31 at &3 ave , howard st. & centre st.h
8.2338
9.0
10.6346

164

7-E 31 at &3 Ave , Howard st. & Centre St.
10-6346

165
  1. millerrenee
  2. 82
  3. 1746
  4. 5
  5. 142
  6. 853
  7. ‘York St & Jay St’ & ‘York St & Jay St’
  8. 2338
  9. 0
  10. 6346
166
  1. millerrenee
  2. 82
  3. 1746
  4. 5
  5. 142
  6. 853
  7. E 31 St & 3 Ave , Howard St & Centre St
  8. 2338
  9. 0
  10. 6346
167

db.customers.findOne({email:“nicoleanderson@hotmail.com”}).username
millerrenee

db.movies.findOne({title:“The Kid Brother”}).runtime
82

db.transactions.findOne({account_id:{"$gt":183500, “$lt”:184000}}).transaction_count
94

db.sales.aggregate([{$match:{customer, email:“kave@we.com”}}])
???

db.posts.countDocuments({title:“Bill of Rights”})
142

db.zips.findOne({city:“CLEVELAND”}).loc
{ y: 33.992106, x: 86.559355 }

db.restaurants.countDocuments({“borough”: “Bronx”})

2338

168
  1. millerrenee
  2. 82
  3. 1746
  4. 5
  5. 142
  6. 853
  7. E31 St & 3 Ave, Howard St & Centre St
  8. 2338
  9. 1436
  10. 6436
169

1.db.customers.find({email.com:" nicoleanderson@hotmail.com"}) = millerrene
2.db.movies.find({“title”:“The Kid Brother”}) = 82
3.1746
4.765
5.db.posts.countDocuments({“tittle”:“Bill of Rights”}) = 142
6.
7.E 31 at &3 Ave , Howard St & Centre St
8.db.restaurants.countDocuments({“borough:Bronx”}) = 2338
9.0
10.6346

171
  1. db.customers.find({email:“nicoleanderson@hotmail.com”})
    Answer: username: ‘millerrenee’
  2. db.movies.find({“title”: “The Kid Brother”})
    Answer: 82
  3. 1746
    4.765
  4. db.posts.countDocuments({“title”: “Bill of Rights”})
    .Answer: 142
  5. 20
    7.267
  6. db.restaurants.countDocuments({“borough”: “Bronx”})
    Answer: 2338
  7. db.restaurants.countDocuments({“sample_training.inspection”:“business name”({‘address.countrty’:{$in:[JAMAICA$gt,11400{“cerificate_number”:$gt9453)}]
    633
173
  1. millerrenee
  2. 82
  3. 1746
  4. the customer satisfaction is 5
  5. 142853
  6. 853
  7. W56ST and 4Ave st and 8ave
  8. 2338
  9. 0
  10. 6346
174

Q1 - username=millerrenee
Q2- runtime=82
Q3- 1746
Q4- satisfaction=5
Q5- 142
Q6- y 35.06537
x 82.609256
Q7- Howard St & Centre St and 5 Ave & E 78 St
Q8- 2338
Q9- 1436
Q10- 6346

175

1-millerrenee
2-82
3-1746
4-5
5-142
6-853
7-E 31 at & 3 ave, howard st. & centre st.
8-2338
9-0
10-6346

176

1). Millerrenee
2). 82
3). 1746
4). 765
5). 142
6). 853
7). E 31 at &3 Ave , Howard st. & Centre St.
8). 2338
9). 1436
10). 6346

177

83
1478
5
142
142
17278
bsichus bc