Skip to content

README.md

Latest commit

 

History

History
36 lines (30 loc) · 1.17 KB

README.md

File metadata and controls

36 lines (30 loc) · 1.17 KB

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.