This project shows a relational database built to store client and transaction data, along with SQL queries used to organize and summarize the information.

I created the database structure, connected the tables, and wrote queries to review the data. The goal was to keep the data organized and use SQL to generate simple reports.

• Created tables with primary and foreign keys
• Connected the tables through relationships
• Wrote JOIN queries to combine data
• Used GROUP BY, SUM, and COUNT for reporting

I also added a separate queries.sql file with extra queries for reporting and data review.

It includes queries for:

• Joining clients with their orders
• Counting total orders per client
• Calculating total spending
• Filtering records by date

• Understanding of relational database structure
• Ability to work with connected tables
• Experience using SQL for reporting and analysis

• MySQL
• SQL