Azure Cosmos DB

SELECT 
    u.id,
    u.name,
    u.email,
    COUNT(o.id) as order_count,
    SUM(o.total) as total_spent
FROM users u 
JOIN orders o IN u.orders
WHERE u.city = 'Seattle' 
    AND o.date >= '2024-01-01'
GROUP BY u.id, u.name, u.email
ORDER BY total_spent DESC

db.users.aggregate([
    {
        $match: { 
            city: "Seattle",
            "orders.date": { $gte: "2024-01-01" }
        }
    },
    {
        $unwind: "$orders"
    },
    {
        $group: {
            _id: "$_id",
            name: { $first: "$name" },
            total_spent: { $sum: "$orders.total" },
            order_count: { $sum: 1 }
        }
    },
    { $sort: { total_spent: -1 } }
])

// Find friends of friends who like similar products
g.V('user123')
  .out('follows')
  .out('follows')
  .where(
    out('likes')
    .in('likes')
    .hasId('user123')
  )
  .dedup()
  .values('name')
  .limit(10)