Code Monkey home page Code Monkey logo

mongo_peoplebase's Introduction

Mongo peoplebase

Here are eight famous people:

Id First Name Last Name Year of Birth Year of Death
1 Marilyn Monroe 1926 1962
2 Abraham Lincoln 1809 1865
3 Nelson Mandela 1918 2013
4 Winston Churchill 1874 1965
5 Bill Gates 1955
6 Charles Darwin 1809 1882
7 Pele 1940
8 Fidel Castro 1926
  1. Create a mongo database and a collection called people that would store the information presented above.

  2. Create a query or a series of queries that would fill the table with the information above. Put the query/queries below:

    ... here goes your code ...
  3. Create a query that would return everything from the table:

    ... here goes your code ...
  4. Create a query that would return a single row: the person with the ID of 5.

    ... here goes your code ...
  5. Create a query that would return the four people with the following IDs: 1, 3, 7, 8.

    ... here goes your code ...
  6. Create a query that would return all the people except the person with the ID of 4 (Winston Churchill).

    ... here goes your code ...
  7. Create a query that would select the people who were born after 1920:

    ... here goes your code ...
  8. Create a query that would select the living people:

    ... here goes your code ...
  9. Create a query that would return everyone who has died:

    ... here goes your code ...
  10. Create a query that would select the people with their first starting with an M:

    ... here goes your code ...
  11. Create a query that would select the people with either their first or last name starting with a C:

    ... here goes your code ...
  12. Create a query that would select the people born after 1900 with their last name starting with a C:

    ... here goes your code ...
  13. Create a query that would select all the people except those whose last name starts with a C:

    ... here goes your code ...
  14. Create a query that would select the people whose first name starts with a letter that precedes M in the English alphabet:

    ... here goes your code ...
  15. Create a query that would return all the people sorted by their last name alphabetically:

    ... here goes your code ...
  16. Create a query that would return the living people sorted in the reverse alphabetical order by their first name.

    ... here goes your code ...
  17. Create a query that would return the people sorted by their year of birth in the descending order, and then (if two or more people share the same year of birth) by their last name alphabetically:

    ... here goes your code ...
  18. Set everyone’s last name to your last name:

    ... here goes your code ...
  19. Update the first name of everyone who was born before 1900 to your favorite character’s name:

    ... here goes your code ...
  20. Add 1 to both the year of birth and year of death for everyone whose ID is less than 5:

    ... here goes your code ...
  21. Delete from the table everyone who died before 2000:

    ... here goes your code ...
  22. Delete everyone from the table:

    ... here goes your code ...

Don’t forget to create a pull request.

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.