Spotify_Data_Analysis_SQL

# Spotify User Engagement Analysis

## Top 10 Most Streamed Tracks (Last 30 Days)

```sql
SELECT track_id, COUNT(*) as stream_count
FROM user_listening_history
WHERE timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
GROUP BY track_id
ORDER BY stream_count DESC
LIMIT 10;
```

## User Listening Patterns by Time of Day

```sql
SELECT HOUR(timestamp) as hour_of_day, COUNT(*) as stream_count
FROM user_listening_history
GROUP BY hour_of_day
ORDER BY hour_of_day;
```

## Trends in User Engagement (Past Year)

```sql
SELECT DATE_FORMAT(timestamp, '%Y-%m') as month, COUNT(*) as stream_count
FROM user_listening_history
WHERE timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 1 YEAR)
GROUP BY month
ORDER BY month;
```