🛒 Sales Analysis with PostgreSQL

A mini project to analyze sales, customers, and payments using PostgreSQL.

📂 Structure

• schema/ → DDL scripts for all tables
• data/ → insert scripts for sample data
• queries/ → analysis queries sql

🚀 Features

• Customer & order management schema
• Monthly sales trends
• Top products & categories
• Customer ranking & order frequency
• Payment method success ratio
• Advanced queries using Window functions & Subqueries

🛠️ Tech

• PostgreSQL 17
• SQL only used (no external framework)

🔑 How to Run

1. Clone repo

   git clone https://github.com/yourusername/sales-analysis-postgres.git
   cd sales-analysis-postgres