西部熱線-西部新聞網 | 助力西部開發,關注西部民生! |
adtop
adtop01
當前位置: 西部熱線 > 西部經濟 > 財經

講解MongoDB編程作業、數據庫編程設計調試

作者:feitian    欄目:財經    來源:西部熱線    發布時間:2019-11-04 10:47

INF 551 – MongoDB Lab

100 points

Due: 11/1/2019, Friday

Consider the New York Times best seller dataset (https://www.kaggle.com/cmenca/new-york-times?hardcover-fiction-best-sellers/). Import the dataset: nyt2.json, into your MongoDB database. 

Write a MongoDB operation (find, aggregate, update, etc) for each of the following questions:

1. Find out the number of books whose title contains “history” (case insensitive).

2. Find out how many book were ranked numbered 1 (according to the overall “rank” value). 

3. Find out the highest price of the books whose overall rank is top 20 (rank value is from 1 to 20). 

(Hint: use aggregate() with a match() for finding the qualified books and then $group, setting _id 

set to null, to find out the max value of price among all matched books).

代寫MongoDB留學生作業、數據庫編程設計作業調試、代做數據庫程序語言作業代做4. Find out, for each publisher, the number of books it published. (list 20 of the query result in .txt)

5. Find out publishers who publish at least 10 books. (list 20 of the query result in .txt)

6. Find out the number of distinct publishers.

7. Find the titles of books published by “Harper” and appeared in the best-selling list at least 5 

times. Output the titles in the descending order. (list first 10 of the query result in .txt)

8. Find out the average price of books published by “Harper”.

9. Find the most productive authors (i.e., authors who published the largest number of books).

10. Change the price of book “Breathless” to 28.5. (paste the response after the update in .txt)

Submit a zip file that contains your queries and results.

Submission

1. Name your files as <firstname>_<lastname>_q1.txt, <firstname>_<lastname>_q2.txt, and so on.

2. Submit all .txt files in a zip file with the naming convention: <firstname>_<lastname>_lab3.zip.

(example content of .txt files)

因為專業,所以值得信賴。如有需要,請加QQ:99515681或郵箱:[email protected] 微信:codehelp

adl03
adr1
adr2
七夕情缘 福州麻将有啥技巧 微信哪个捕鱼好玩 南京麻将技巧 贵阳捉鸡麻将微乐 信誉幸运飞艇群 pk10精准计划 我想举报闲聊麻将群赌博 广西快3遗漏统计值 平台捕鱼漏洞破解 送金币的棋牌游戏? 四川麻将血战单机版 贵州十一选五一定牛 拉萨一条龙微信交流群 山西十一选五开奖走势图乐彩网 中3d组选多少钱 排列5彩票开奖结果