I have a database like so: { genre: Rock, year: 2019, play count: 15,000}, { genre: Rock/Metal,
Question:
I have a database like so: { "genre": "Rock", "year": "2019", "play count": "15,000"}, { "genre": "Rock/Metal", "year": "2019", "play count": "16,000"}, { "genre": "Hip Hop", "year": "2015", "play count": "11,000"}, { "genre": "Hip Hop/R&B", "year": "2015", "play count": "5,000"}, { "genre": "R&B", "year": "2016", "play count": "25,000"}, { "genre": "Pop/R&B", "year": "2016", "play count": "15,000"},
....
NoSQL/MongoDB queries to find:
1. What year has the most Rock song in it? (genre column that contains "rock")
2. What year has the most song in it?
3. What genre had the most play count over 10,000?
4. Least played genre?
Auditing The Art And Science Of Assurance Engagements
ISBN: 9780136692089
15th Canadian Edition
Authors: Alvin A. Arens, Randal J. Elder, Mark S. Beasley, Chris E. Hogan, Joanne C. Jones