solve question 2 in exam.

1 files changed, 34 insertions, 0 deletions

diff --git a/week-7/question2.js b/week-7/question2.js
new file mode 100644
index 0000000..2e6ba9e
--- /dev/null
+++ b/week-7/question2.js
@@ -0,0 +1,34 @@
+use enron;
+
+//db.messages.findOne();
+
+db.messages.aggregate([
+  {
+    $match: {
+      $or:[
+        { 'headers.From': 'susan.mara@enron.com' },
+        { 'headers.From': 'soblander@carrfut.com' },
+        { 'headers.From': 'evelyn.metoyer@enron.com' },
+      ]
+    }
+  },
+  { $unwind: '$headers.To' },
+  {
+    $project: {
+      _id: '$headers.To',
+      to: '$headers.To',
+      from: '$headers.From',
+    }
+  },
+  {
+    $group: {
+      _id: { 
+        from: '$from',
+        to: '$to',
+      },
+      sum: { $sum: 1 }
+    }
+  },
+  { $sort: { sum: -1 } },
+  { $limit: 1 }
+]).pretty();