130
  1. db.customers.find({“email”: “nicoleanderson@hotmail.com”})
    Answer = millerrenee

2)db.movies.find({“title”: “The Kid Brother”})
Answer = 82

Q3) transaction_count: 1746
4) 765
5. db.posts.countDocuments({“title”: “Bill of Rights”})
Ans: 142
6)853
7 -E 31 at &3 Ave, Howard St & Centre st
8. db.restaurants.countDocuments({“borough”: “Bronx”})
Ans: 2338
9-0
10-6346

131

Answers-

1 - millerrenee
2-82
3-1746
4 - 5
5-142
6-852
7-
8-2338
9-0
10-

132

1.db.customers.find({“email” : “nicoleanderson@hotmail.com”},{username:1,_id:0})
output: {username: ‘millerrenee’}

2.db.movies.find({title:“The Kid Brother”},{“runtime”:4,_id:0})
output : {runtime: 82}

3.1746

4.db.sales.find({“customer.email” : “kave@we.com”},{customer.satisfaction:1,_id:0})
output: 5

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

6.853
7.‘start station name’: ‘York St & Jay St’, and ‘start station name’: ‘Wythe Ave & Metropolitan Ave’,

8.db.restaurants.countDocuments({“borough”: “Bronx”})
output:2338
9.0
10.6346

133

1: username: millerrenee
2: 82
3: 1746
4:765
5: 142
6: 853
7: E 31 St & 3 Ave , Howard St & Centre St
8: 2338
9: 0
10: 6346

134

  1. millerrenee

  2. 82

  3. 1746

  4. the customer satisfaction is 5

  5. 142

  6. 853

  7. W56ST and 4Ave st and 8ave

  8. 2338

  9. 0

  10. 6346

135
  1. millerrenee
  2. runtime: 82
  3. 1746
  4. 765
  5. 142
  6. 853
  7. E 31 St & 3 Ave , Howard St & Centre St
  8. 2338
136
  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
137
  1. username: ‘millerrenee’
  2. runtime: 82
  3. 1746
  4. customer.satisfaction:5
  5. 142
138

  1. Millerrenee

  2. 82

  3. 1746

  4. invalid

  5. 142

  6. 853

  8. 2338

  9. 1436
    10.6346

139

q1. millerrenee
q.2 82
q3. 17464
q4.
q5. 142
q6.853
q7. E 31 at &3 ave, howard st & center
q8. 2338
q9. 0
q10.

141

kya mtlb bhai copy krna bhi nhi aata

142
  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

done now

143
  1. answer – username: ‘millerrenee’
  2. answer - 82
  3. answer - 1752
    4)answer - 765
    5)answer - 142
  4. answer - 853
  5. –
  6. answer – 0
    10 ) –
145
  1. millerrenee
    2.82
    3.1
    4.5
    5.142
    6.853
    7.E 31 at &3 Ave, Howard St & Centre st
    8.2338
    9.0
    10.6346
146

1.use sample_analytics
db.customers.find({“email":"nicoleanderson@hotmail.com”},{_id:0,username:1})
2. use sample_mflix
db.movies.find({title:“The Kid Brother”},{_id:0,runtime:1})
3. use sample_analytics
4.
5. use sample_trainings
db.posts.countDocuments({title:“Bill of Rights”})
6. use sample_training
db.zips.find({city:“CLEVELAND”,pop:{$gt:500},pop:{$lt:1000}},{_id:0,loc:1})
7.use sample_training
db.trips
8.use sample_restaurants

  2. use sample_airbnb
148

1.) millerrenee
2) 82
3) 94
4) 5
5) 142
6) x: 35.06537, y: 82.609256
7) 1. Clark St & Henry St
2. Central Park West $ W 72 St
8 )
9)
10) 6346

149
  1. Millerrenee
  2. 82
  3. 1746
  4. 765
  5. 142
  6. 853
  7. E 31 at &3 ave , howard st. & centre st.h
  8. 2338
  9. 1436
  10. 6346
150

1)millerrenee
2) 82
3)
4) 5
5) 142
6) y: 35.06537 , x:82.609256
7) Clark St & Henry St Central Park West & W 72 St
8) 85
9)
10)

151
  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
    6.20
  5. db.restaurants.countDocuments({“borough”: “Bronx”})
    8.Answer: 2338
    7.267
  6. db.restaurants.countDocuments({“sample_training.inspection”:“business name”({‘address.countrty’:{$in:[JAMAICA$gt,11400{“cerificate_number”:$gt9453)}]
    633
153
  1. ‘millerrenee’
  2. 82
  3. 258
  4. 5