Create database and collection

1. Create a database named projectDB with the command use projectDB
2. Create collection named person witht the command db.createCollection("person"})
3. Add some data with below code

   db.person.insert({id_person:201,firstname:'Jim',lastname:'Morrison',city:'TURKU',birthyear:1985,salary:44})
   db.person.insert({id_person:203,firstname:'Liisa',lastname:'River',city:'HELSINKI',birthyear:1991,salary:39})
   db.person.insert({id_person:206,firstname:'Matt',lastname:'Daniels',city:'TAMPERE',birthyear:1991,salary:34})
   db.person.insert({id_person:202,firstname:'Jim',lastname:'Smith',city:'TURKU',birthyear:1988,salary:39})
   db.person.insert({id_person:205,firstname:'Lisa',lastname:'Simpson',city:'HELSINKI',birthyear:1985,salary:36})
   db.person.insert({id_person:204,firstname:'Ann',lastname:'Jones',city:'TURKU',birthyear:1979,salary:44})
   

Queries

1. db.person.find().pretty
2. db.person.find({},{_id:0,firstname:1,lastname:1})
3. db.person.find({},{_id:0,firstname:1,lastname:1,city:1})
4. db.person.find({city:"TURKU"},{_id:0,firstname:1,lastname:1,city:1})
5. db.person.find({city:"TURKU","HELSINKI"},{_id:0,firstname:1,lastname:1,city:1})
6. db.person.find({city:"TURKU","HELSINKI"},{_id:0,firstname:1,lastname:1,city:1})
7. db.person.find({city:"TURKU","HELSINKI"},{_id:0,firstname:1,lastname:1,city:-1})