This project explores employee and financial data from the company_paycheck database. It contains staff information such as age, job, marital status, education, housing, loans, balances, and outcomes of campaigns.
The queries below demonstrate how to analyze employee details, balances, and conditions to extract insights.
Clone this repo
Import the SQL file into MySQL / PostgreSQL
Run the queries in your SQL editor
Modify or add queries to explore insights
SQL table creation
Data insertion
Aggregate functions (SUM, AVG, MAX, MIN)
Subqueries
Filtering with WHERE
Real-world style datasets