Question: Need help with this The Scenario: The Google Apps database stores many of the apps developed for android smart phones and the corresponding reviews associated

Need help with this Need help with this The Scenario: The Google Apps database stores many

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. Find 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. Find the total number of apps for each of the 6 content rating categories. 3. Find the top 3 highest rated apps in the category of 'TOOLS' that have more than 225,000 reviews

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!