homework 5.2

1 files changed, 22 insertions, 0 deletions

diff --git a/week-5/52.js b/week-5/52.js
new file mode 100644
index 0000000..e266491
--- /dev/null
+++ b/week-5/52.js
@@ -0,0 +1,22 @@
+use test;
+db.zips.aggregate([
+  {
+    $match: {
+      $or: [{ state: 'CA'}, { state: 'NY'}],
+      pop: { $gte: 25000 }
+    }
+  },
+  {
+    $project: {
+      _id: 0,
+      //state: '$state',
+      population: '$pop',
+    }
+  },
+  {
+    $group: {
+      _id: '$state',
+      average: { $avg: '$population' }
+    }
+  },
+])