Given the table imdbs as the following attributes(columns):…
Given the table imdbs as the following attributes(columns): Ids: Number Title: String Genre: Director: Year: Number Runtime: Number Rating: Float Votes: Number Revenue: Float Suppose we transfer the above table into collection name “imdb” in MongoDB database name “db”. Create the MongoDB shell commands that are equivalent as the following SQL Command: SELECT Title, Ids FROM imdbs WHERE year BETWEEN 2012 AND 2014; For example: SQL Command MongoDB Shell Command SELECT * FROM t1; db.t1.find( ); or db.t1.find({ });