1 username: ‘millerrenee’
2 82
3 1746
4 765
5 142
6 20
7 E 31 St & 3 Ave , Howard St & Centre St
8 2338
9 0
10
Nikhil_Vij
(Nikhil Vij)
107
1)millerrenee
2)runitime 82
3)94
4)invalid
5)142
6)853
7)
8)2338
9)
10)
1)db.customers.find({“email”: “nicoleanderson@hotmail.com”})
ans:millerrenee
2)db.movies.find({“title”: “The Kid Brother”})
ans:82
3)1746
4) 765
5)db.posts.countDocuments({“title”: “Bill of Rights”})
ans : 142
6)853
8)db.restaurants.countDocuments({“borough”: “Bronx”})
ans: 2338
1.millerrenee
3.1746
4. the customer satisfaction is 5
5. 142
8.2338
7. W 56 St and 6 Ave & W 45 St and 8 Ave
1-username: ‘millerrenee’
2- The Kid Brother
3- 1746
4- 765
5-142
6-0
7- ‘start station name’: ‘York St & Jay St’, and ‘start station name’: ‘Wythe Ave & Metropolitan Ave’,
8-2338
9-0
Q1) ‘millerrenee’
Q2) 82
Q3) 94
Q5) 142
Q7) ‘York St & Jay St’ & ‘York St & Jay St’
1- db.customers.find({“email”: “nicoleanderson@hotmail.com”})
ans:millerrenee
2- db.movies.find({“title”: “The Kid Brother”})
ans:82
3- 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
db.customers.find({email:“nicoleanderson@hotmail.com”})
Answer: username: ‘millerrenee’
db.movies.find({“title”: “The Kid Brother”})
Answer: 82
Answer: 1746
db.posts.countDocuments({“title”: “Bill of Rights”})
Answer: 142
8.db.restaurants.countDocuments({“borough”: “Bronx”})
Answer: 2338
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
Ba3a
(Aryan 'Ba3a' Kumar)
128
millerrenee
82
1
5
142
853
E 31 at &3 Ave, Howard St & Centre st
2338
0
6346
1 Like