Day6P4.js

/* 
Write a MongoDB query to display student names who has an attendance percentage 
between 85 and 95 (inclusive)

Database: test
Collection: students

Sample Document:
----------------
{
    "studentId": "STU001",
    "name": "John Doe",
    "age": 21,
    "gender": "Male",
    "department": "Computer Science",
    "year": "Senior",
    "gpa": 3.7,
    "course1": "CS101",
    "course2": "CS201",
    "course3": "EE101",
    "email": "john.doe@example.com",
    "phoneNumber": "+1-202-555-0101",
    "street": "123 Main St",
    "city": "Somewhere",
    "state": "NY",
    "zipCode": "10001",
    "attendancePercentage": 90,
    "graduatingYear": 2025,
    "scholarship": "Dean's List",
    "activity1": "Coding Club",
    "activity2": "Soccer"
}

Note: 
=====
To write the query, use printjson() method from 'mongosh' module
e.g., To display all the documents from 'employees' collection 
from 'test' database.
    
    => printjson( db.getSiblingDB('test').students.find() )
    Where,
    db => databse connection object
    getSiblingDB('test') => "test" is database name
    students => collections name
    find => method to retrieve all the matched docuemnts

*/
printjson(db.getSiblingDB('test').students.find(
    {
        attendancePercentage:{$gte:85,$lte:95}
    },
    {_id:0,name:1}));