Analysis with SQL

📌 Project Overview

This project demonstrates SQL-based data analysis using a music database. The objective was to create database tables, populate them with data, and solve multiple analytical SQL queries related to bands, albums, and songs.

🗄️ Database Setup

1. Executed schema.sql to create the database and base tables.
2. Created the songs table with the following columns:
   • id
   • name
   • length
   • album_id
3. Executed data.sql to populate the tables with sample data.

📊 Analysis Performed

The following analyses were completed using SQL queries:

• Identified bands with and without albums
• Found the oldest album and the longest album
• Calculated average song length
• Retrieved the longest song from each album
• Counted the number of songs per band
• Derived album decades using year-based calculations
• Filtered albums using text and date-based conditions

All queries are documented and available in queries.sql.

🛠 Tools Used

• MySQL
• MySQL Workbench
• GitHub

✅ Outcome

This project showcases practical SQL skills including joins, subqueries, aggregations, filtering, and real-world analytical problem solving.