The Scenario: The Google Apps database stores many of the apps developed for android smart phones and the corresponding reviews associated with the apps. The database can be created by running the following script: Create_Google.sql The Request: You are working for an independent third-party company that is determining for Google the current app hits and flops, as well as aggregated data for apps being developed and deployed for the Android platform. Requirements and Information: 1. Provide a visualization for the highest-rated apps with a user rating of at least 4.6, have at least 1000 reviews, and does not have a content rating of 'Everyone! 2. Provide a visualization for the total number of apps for each of the 6 content categories. 3. Provide a visualization for the top 3 highest rated 'TOOLS' apps that have more than 225,000 reviews. Also, include at least 1 positive review for each of the top 3 apps in the visualization. What to Submit: Upload a completed lab report answering all questions and including the scripts that pulled the data and the visualizations used to effectively communicate the results The Scenario: The Google Apps database stores many of the apps developed for android smart phones and the corresponding reviews associated with the apps. The database can be created by running the following script: Create_Google.sql The Request: You are working for an independent third-party company that is determining for Google the current app hits and flops, as well as aggregated data for apps being developed and deployed for the Android platform. Requirements and Information: 1. Provide a visualization for the highest-rated apps with a user rating of at least 4.6, have at least 1000 reviews, and does not have a content rating of 'Everyone! 2. Provide a visualization for the total number of apps for each of the 6 content categories. 3. Provide a visualization for the top 3 highest rated 'TOOLS' apps that have more than 225,000 reviews. Also, include at least 1 positive review for each of the top 3 apps in the visualization. What to Submit: Upload a completed lab report answering all questions and including the scripts that pulled the data and the visualizations used to effectively communicate the results
