# Aggregation sort & group

## Input

```
db.test.drop();

db.test.insert([{
    id: 1,
    name: "John",
    review: "only one review",
    dateCreated: ISODate("2017-02-23 02:35:11.420Z")
}, {
    id: 3,
    name: "Sam",
    review: "second entered",
    dateCreated: ISODate("2017-02-23 02:41:42.300Z")
}, {
    id: 2,
    name: "Sam",
    review: "fist enterd",
    dateCreated: ISODate("2017-02-23 02:36:32.150Z")
}, {
    id: 5,
    name: "Thierry",
    review: "fist enterd121212",
    dateCreated: ISODate("2017-02-23 02:36:32.150Z")
}])
```

## Aggregation

```
db.test.aggregate([{
    $sort: {
        "dateCreated": -1
    }
}, {
    $group: {
        _id: "$name",
        review: {
            "$first": "$review"
        },
        dateCreated: {
            "$first": "$dateCreated"
        },
        id:{
        	"$first": "$id"
        }
    }
}])
```

## Output

```
{ "_id" : "John", "review" : "only one review", "dateCreated" : ISODate("2017-02-23T02:35:11.420Z"), "id" : 1 }
{ "_id" : "Thierry", "review" : "fist enterd121212", "dateCreated" : ISODate("2017-02-23T02:36:32.150Z"), "id" : 5 }
{ "_id" : "Sam", "review" : "second entered", "dateCreated" : ISODate("2017-02-23T02:41:42.300Z"), "id" : 3 }
```