SQL USED: I imported the data using SQLite online per the guided video of LoreSoWhat in YouTube.
Queries: I followed the SQL queries from the video here
DATA SOURCE: Dataset link courtesy of LoreSoWhat google drive folder
USING MY OWN SQL QUESTIONS THAT SPARKED MY CURIOSITY
Further analysis of the Apps to beat based on previous exploratory analysis and assumptions for the App Developer:
- PAID apps that have top user ratings among top 5 categories from previous analysis
- If App developer still wants to develop games, what are the games to beat
- based on paid, user_rating, cont_rating, etc.
SQL USED: DB Browser for SQLite
Queries: I created my own queries in this sql file
Findings: The sheet named "Non-Guided_SQL_Questions" has the outputs from the Queries I made. excel file - Click 'View raw' to Open the file online