sql-business-analysis

SQL project focused on data analysis, filtering, aggregation, and business insights using real datasets.

📊 Datasets

This project uses multiple datasets:

• funcionarios.csv
• produtos_mercado.csv
• filmes.csv
• uso_academia.csv

🔍 Key Analysis

Main analyses performed in this project:

• Filtering employees based on salary, age, and status
• Identifying products with low stock or promotions
• Calculating averages, totals, minimum and maximum values
• Grouping data by category and state
• Applying conditions using WHERE, HAVING, and ORDER BY

🧠 SQL Concepts Used

• SELECT
• WHERE
• GROUP BY
• HAVING
• ORDER BY
• COUNT()
• AVG()
• SUM()
• MIN()
• MAX()
• IN / AND / OR

📁 Project Structure

data/ funcionarios.csv produtos_mercado.csv filmes.csv uso_academia.csv

queries/ analysis_queries.sql

🚀 Objective

The goal of this project is to practice SQL for data analysis and develop skills relevant to real-world business scenarios.