Answered step by step
Verified Expert Solution
Question
1 Approved Answer
For each of the following, you need to write a query and also show the output ( result returned from the shell ) submit a
For each of the following, you need to write a query and also
show the output result returned from the shell submit a pdf
file
after preparing the queries, run them one by one and record
your work short video, max minutes, no need for audio
submit the video
Create a new database called: your firstNamefamilyName
Switch to the DB created in step
Create a new collection called: your firstNamecollection
Write query to make sure that the collection was created
Add persons to the collection; each one of them has the
following properties: name, university name, registration
year, student ID and average value from to one of
these entries must has your info
write a query to return all persons in the collection
write a query that return only persons
write a query to return the top persons based on their
average
write a query that return persons whose average is above
and who registered in university after
update the person that has your info based on your student
Id change average instead from scale to by dividing
it by
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started