Welcome to my SQL projects repository! This repository contains case studies that demonstrate my SQL skills and ability to solve real-world problems using structured query language. Each project includes a detailed analysis, queries, and insights derived from the data.
📁 Projects Included
This case study focuses on analyzing NFT transaction data to uncover trends in the digital asset space and provide insights for investors and platform operators.
- Track the most traded NFTs by volume and value.
- Analyze the distribution of buyers and sellers.
- Identify patterns in transaction frequency over time.
- Assess the growth of NFT collections.
This case study involves analyzing data from a bike rental shop to gain insights into customer behavior, rental trends, and operational performance.
- Identify the most popular rental hours.
- Calculate the revenue generated during peak hours.
- Determine the performance of different bike types.
- Data filtering and aggregation.
- Use of functions like GROUP BY, JOIN, and CASE.
- Advanced query optimization.
- Use of CTE (Common Table Expressions) for cleaner queries.
- Statistical analysis using SQL functions.
🛠️ Tools Used
SQL Dialect: MySQL
Database: Mock datasets for both case studies.