Question
Please Help! Create a database named city with a document composed of the key-value pairs listed below in a collection named inspections. Key Value id
Please Help!
Create a database named city with a document composed of the key-value pairs listed below in a collection named inspections.
| Key | Value |
| id | 20032-2017-ACME |
| certificate_number | 9998888 |
| business_name | ACME Explosives |
| date | Todays date |
| result | Business Padlocked |
| sector | Explosive Retail Dealer 999 |
| address | number -> 1721 street -> Boom Road city -> BRONX zip -> 10463 |
-
Answer the following questions using MongoDB queries:
a. What is the distinct list of inspection results in the current inspections collection? How many are in the list? Use JavaScript code to find the answer.
b. What is the difference in the date data type for the business named AUSTIN 2012 versus your business document insertion of Acme Explosives?
c. How many businesses have been padlocked? (See Value column above.)
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
PostgreSQL 10 High Performance Expert Techniques For Query Optimization High Availability And Efficient Database Maintenance
Authors: Ibrar Ahmed ,Gregory Smith ,Enrico Pirozzi
3rd Edition
1788474481, 978-1788474481
