05-Aggregate.txt

Y����ma

Veri

	db.sales.insert([
		{"productName":"Cep Telefonu","salesPrice":1200,"salesQuantity":2},
		{"productName":"Masa�st� Bilgisayar","salesPrice":3200,"salesQuantity":3},
		{"productName":"Diz�st� Bilgisayar","salesPrice":4150,"salesQuantity":1},
		{"productName":"Masa�st� Bilgisayar","salesPrice":3300,"salesQuantity":2},
		{"productName":"Diz�st� Bilgisayar","salesPrice":4350,"salesQuantity":3}
	])
�bek 
	
	db.sales.aggregate(
		{
			$group:{
				_id : "$productName",
				"salesPriceAverage":{$avg:"$salesPrice"}
			}
		}
	)
	db.sales.aggregate(
		{
			$group:{
				_id : "$productName",
				"salesQuantitySum":{$sum:"$salesQuantity"}
			}
		}
	)	
	db.sales.aggregate(
		{
			$group:{
				_id : "$productName",
				"salesCount": {$sum:1}
			}
		}
	)	

	db.sales.aggregate(
		{
			$group:{
				_id : "$productName",
				"salesQuantitySum":{$sum:"$salesQuantity"},
				"salesPriceAverage":{$avg:"$salesPrice"},
				"salesQuantityMin":{$min:"$salesQuantity"},
				"salesPriceMax":{$max:"$salesPrice"},
				"salesCount": {$sum:1}
			}
		}
	)	
	
Yans�tma

	db.sales.aggregate(
		{
			$group:{
				_id : "$productName",
				"amountSum":{ $sum: {$multiply:["$salesQuantity", "$salesPrice"]} },
				"quantitySum":{ $sum:"$salesQuantity"}
			}
		},
		{
			$project: {
				"amountSum":1
			}
		}
	)
	
	db.sales.aggregate(
		{
			$group:{
				_id : "$productName",
				"amountSum":{ $sum: {$multiply:["$salesQuantity", "$salesPrice"]} },
				"quantitySum":{ $sum:"$salesQuantity"}
			}
		},
		{
			$project: {
				"weightedAverage": { $divide: [ "$amountSum", "$quantitySum" ] }
			}
		}
	)
E�le�me

	db.sales.aggregate(
		{ 
			$match : { 
				productName : "Masa�st� Bilgisayar" 
			} 
		}
	)
	db.sales.aggregate(
		{
			$group:{
					_id : "$productName",
					"salesCount": {$sum:1}
			}
		},
		{ 	
			$match : { 
				"_id" : "Masa�st� Bilgisayar" 
			} 
		}
	)