MongoDB Query

db.accounting.aggregate([					
	{$match:{'institute':'상도','date':{$lt:'2016-02-09'}}},				
	{$group:				
		{'_id':{'institute':'$institute'},'income':{$sum:'$income'},'outcome':{$sum:'$outcome'}}			
	}
])

db.accounting.aggregate([					
	{ "$match" : { "institute" : "상도"}},
	{ "$project" : { }},
	{ "$group" : { 
			"_id" : { "institute" : "$institute"} , 
			"income" : { "$sum" : "$income"} , 
			"outcome" : { "$sum" : "$outcome"}
		}
	},
	{ "$sort" : { }},
	{ "$limit" : 100000},
	{ "$skip" : 0},
	{ "$unwind" : { }}
])

db.getCollection('accounting').insert({
	'seqno':NumberInt(1),
	'institute' : '상도',
	'date' :'2015-08-19',
	'update_date' : '2015-02-01',
	'account' :'비품',
	'detail':'프로젝터',
	'customer' : 'g9',
	'code' : 'card',
	'plan' : '',
	'income' : NumberInt(0),
	'outcome' : NumberInt(79900),
	'document' : '',
	'secretary' : 'pharosadmin',
	'remarks' : 'jks card'
})