MongoDB:
show dbs
show collections
db.getCollection('bills').find({})
db.getCollection('bills').find({}).limit(5)
db.getCollection('users').find({}, {"user_details.email": 1} )
db.getCollection('bills').find({"owner_details.email": "test03@energo.cn", "status": 1}).sort({"owner_details.email": 1})
db.getCollection('bills').find({ $or: [{"owner_details.email": "test03@energo.cn"}, {"owner_details.email": "test06@energo.cn"} ]}).sort({"owner_details.email": -1})
db.getCollection('bills').find({total_energy_produced:{$ne: 0}, $or: [{"owner_details.email": "test03@energo.cn"}, {"owner_details.email": "test06@energo.cn"} ]}).sort({"owner_details.email": -1})
db.bills.find({total_energy_produced:{$ne: 0} })
db.bills.aggregate([
{$match : {period_from: {"$gte" : ISODate("2018-01-31T01:50:00.000Z"), "$lt" : ISODate("2018-02-28T02:38:00.000Z") }}},
{$group : {_id: "$owner", consumed_total_amount : {$sum : "$total_energy_consumed"}}},
{$sort: {"consumed_total_amount": -1}}
])
db.bills.aggregate([
{$match : {total_energy_produced:{$ne: 0}, period_from: {"$gte" : ISODate("2018-01-31T01:50:00.000Z"), "$lt" : ISODate("2018-02-28T02:38:00.000Z") }}},
{$group : {_id: "$owner", consumed_total_amount : {$sum : "$total_energy_consumed"}}},
{$sort: {"consumed_total_amount": -1}}
])
db.getCollection('bills').find({"owner_details.email": "test06@energo.cn", "period_from" : {"$gte" : ISODate("2017-12-22T04:59:00.000Z"), "$lt" : ISODate("2017-12-22T05:59:00.000Z") } }, {owner: 1, total_clean_energy_bought:1,placed_auction:1})