Data Science Hub
  • Data Science Hub
  • STATISTICS
    • Introduction
    • Fundamentals
      • Data Types
      • Central Tendency, Asymmetry, and Variability
      • Sampling
      • Confidence Interval
      • Hypothesis Testing
    • Distributions
      • Exponential Distribution
    • A/B Testing
      • Sample Size Calculation
      • Multiple Testing
  • Database
    • Database Fundamentals
    • Database Management Systems
    • Data Warehouse vs Data Lake
  • SQL
    • SQL Basics
      • Creating and Modifying Tables/Views
      • Data Types
      • Joins
    • SQL Rules
    • SQL Aggregate Functions
    • SQL Window Functions
    • SQL Data Manipulation
      • String Operations
      • Date/Time Operations
    • SQL Descriptive Stats
    • SQL Tips
    • SQL Performance Tuning
    • SQL Customization
    • SQL Practice
      • Designing Databases
        • Spotify Database Design
      • Most Commonly Asked
      • Mixed Queries
      • Popular Websites For SQL Practice
        • SQLZoo
          • World - BBC Tables
            • SUM and COUNT Tutorial
            • SELECT within SELECT Tutorial
            • SELECT from WORLD Tutorial
            • Select Quiz
            • BBC QUIZ
            • Nested SELECT Quiz
            • SUM and COUNT Quiz
          • Nobel Table
            • SELECT from Nobel Tutorial
            • Nobel Quiz
          • Soccer / Football Tables
            • JOIN Tutorial
            • JOIN Quiz
          • Movie / Actor / Casting Tables
            • More JOIN Operations Tutorial
            • JOIN Quiz 2
          • Teacher - Dept Tables
            • Using Null Quiz
          • Edinburgh Buses Table
            • Self join Quiz
        • HackerRank
          • SQL (Basic)
            • Select All
            • Select By ID
            • Japanese Cities' Attributes
            • Revising the Select Query I
            • Revising the Select Query II
            • Revising Aggregations - The Count Function
            • Revising Aggregations - The Sum Function
            • Revising Aggregations - Averages
            • Average Population
            • Japan Population
            • Population Density Difference
            • Population Census
            • African Cities
            • Average Population of Each Continent
            • Weather Observation Station 1
            • Weather Observation Station 2
            • Weather Observation Station 3
            • Weather Observation Station 4
            • Weather Observation Station 6
            • Weather Observation Station 7
            • Weather Observation Station 8
            • Weather Observation Station 9
            • Weather Observation Station 10
            • Weather Observation Station 11
            • Weather Observation Station 12
            • Weather Observation Station 13
            • Weather Observation Station 14
            • Weather Observation Station 15
            • Weather Observation Station 16
            • Weather Observation Station 17
            • Weather Observation Station 18
            • Weather Observation Station 19
            • Higher Than 75 Marks
            • Employee Names
            • Employee Salaries
            • The Blunder
            • Top Earners
            • Type of Triangle
            • The PADS
          • SQL (Intermediate)
            • Weather Observation Station 5
            • Weather Observation Station 20
            • New Companies
            • The Report
            • Top Competitors
            • Ollivander's Inventory
            • Challenges
            • Contest Leaderboard
            • SQL Project Planning
            • Placements
            • Symmetric Pairs
            • Binary Tree Nodes
            • Interviews
            • Occupations
          • SQL (Advanced)
            • Draw The Triangle 1
            • Draw The Triangle 2
            • Print Prime Numbers
            • 15 Days of Learning SQL
          • TABLES
            • City - Country
            • Station
            • Hackers - Submissions
            • Students
            • Employee - Employees
            • Occupations
            • Triangles
        • StrataScratch
          • Netflix
            • Oscar Nominees Table
            • Nominee Filmography Table
            • Nominee Information Table
          • Audible
            • Easy - Audible
          • Spotify
            • Worldwide Daily Song Ranking Table
            • Billboard Top 100 Year End Table
            • Daily Rankings 2017 US
          • Google
            • Easy - Google
            • Medium - Google
            • Hard - Google
        • LeetCode
          • Easy
  • Python
    • Basics
      • Variables and DataTypes
        • Lists
        • Dictionaries
      • Control Flow
      • Functions
    • Object Oriented Programming
      • Restaurant Modeler
    • Pythonic Resources
    • Projects
  • Machine Learning
    • Fundamentals
      • Supervised Learning
        • Classification Algorithms
          • k-Nearest Neighbors
            • kNN Parameters & Attributes
          • Logistic Regression
        • Classification Report
      • UnSupervised Learning
        • Clustering
          • Evaluation
      • Preprocessing
        • Scalers: Standard vs MinMax
        • Feature Selection vs Dimensionality Reduction
        • Encoding
    • Frameworks
    • Machine Learning in Advertising
    • Natural Language Processing
      • Stopwords
      • Name Entity Recognition (NER)
      • Sentiment Analysis
        • Agoda Reviews - Part I - Scraping Reviews, Detecting Languages, and Preprocessing
        • Agoda Reviews - Part II - Sentiment Analysis and WordClouds
    • Recommendation Systems
      • Spotify Recommender System - Artists
  • Geospatial Analysis
    • Geospatial Analysis Basics
    • GSA at Work
      • Web Scraping and Mapping
  • GIT
    • GIT Essentials
    • Connecting to GitHub
  • FAQ
    • Statistics
  • Cloud Computing
    • Introduction to Cloud Computing
    • Google Cloud Platform
  • Docker
    • What is Docker?
Powered by GitBook
On this page

Was this helpful?

  1. SQL
  2. SQL Practice
  3. Popular Websites For SQL Practice
  4. StrataScratch

Spotify

Last updated 1 year ago

Was this helpful?

Nr
Company
Difficulty
ID
Title
Link
Table

1

Spotify

Easy

ID 9990

Find songs that have more than 3 million streams

2

Spotify

Easy

ID 9992

Find how many times each artist appeared on the Spotify ranking lis

3

Spotify

Easy

ID 9994

Find songs with less than 2000 streams

spotify_worldwide_daily_song_ranking

4

Spotify

Easy

ID 9995

Top 10 Ranked Songs

spotify_worldwide_daily_song_ranking

5

Spotify

Easy

ID 9996

Find the average number of streams across all songs

spotify_worldwide_daily_song_ranking

6

Spotify

Easy

ID 9997

Top 100 Ranked Songs

spotify_worldwide_daily_song_ranking

7

Spotify

Easy

ID 9999

Find songs that are ranked between 8-10

spotify_worldwide_daily_song_ranking

8

Spotify

Medium

ID 9650

Find the top 10 ranked songs in 2010

billboard_top_100_year_end

9

Spotify

Medium

ID 9743

Top 10 Songs

billboard_top_100_year_end

10

Spotify

Medium

ID 9744

The Best Artist

billboard_top_100_year_end

11

Spotify

Medium

ID 9745

Find the best artists in the last 20 years

billboard_top_100_year_end

12

Spotify

Medium

ID 9991

Top Ranked Songs

spotify_worldwide_daily_song_ranking

13

Spotify

Medium

ID 9993

Find artists with the highest number of top 10 ranked songs over the years

spotify_worldwide_daily_song_ranking

14

Spotify

Medium

ID 10283

Find the top-ranked songs for the past 20 years.

billboard_top_100_year_end

15

Spotify

Hard

ID 10173

Days At Number One

spotify_daily_rankings_2017_us, spotify_worldwide_daily_song_ranking

https://platform.stratascratch.com/coding/9990-find-songs-that-have-more-than-3-million-streams?code_type=1
spotify_worldwide_daily_song_ranking
https://platform.stratascratch.com/coding/9992-find-artists-that-have-been-on-spotify-the-most-number-of-times?code_type=1
spotify_worldwide_daily_song_ranking
https://platform.stratascratch.com/coding/9994-find-songs-with-less-than-2000-streams?code_type=1
https://platform.stratascratch.com/coding/9995-top-10-ranked-songs?code_type=1
https://platform.stratascratch.com/coding/9996-find-the-average-number-of-streams-across-all-songs?code_type=1
https://platform.stratascratch.com/coding/9997-top-100-ranked-songs?code_type=1
https://platform.stratascratch.com/coding/9999-find-songs-that-are-ranked-between-8-10?code_type=1
https://platform.stratascratch.com/coding/9650-find-the-top-10-ranked-songs-in-2010?code_type=1
https://platform.stratascratch.com/coding/9743-top-10-songs?code_type=1
https://platform.stratascratch.com/coding/9744-artist-of-the-decade?code_type=1
https://platform.stratascratch.com/coding/9745-find-the-best-artists-in-the-last-50-years?code_type=1
https://platform.stratascratch.com/coding/9991-top-ranked-songs?code_type=1
https://platform.stratascratch.com/coding/9993-find-artists-with-the-highest-number-of-top-10-ranked-songs-over-the-years?code_type=1
https://platform.stratascratch.com/coding/10283-find-the-top-ranked-songs-for-the-past-30-years?code_type=1
https://platform.stratascratch.com/coding/10173-days-at-number-one?code_type=1