blessedmadukoma/retail-orders-pipeline ? reverse-engineered prompt

Build me a retail orders data pipeline project that takes the Kaggle retail orders dataset for 2022 and 2023, cleans it up, and loads it into PostgreSQL in a Docker setup.

I want the notebook to download or read the raw data, remove bad rows and duplicates, standardize the values, and then write the cleaned data into a proper database table. Please also include the SQL needed to explore the data and answer basic business questions like sales by category, trends over time, and top performing products.

Set it up so it runs smoothly with a simple local environment, using a .env file for database settings and a clear way to start the database and any pipeline pieces. If it makes sense, add a basic Airflow style workflow for orchestration, but keep it easy to run and understand. Make sure the code is tidy, documented, and works end to end with the notebook and database connection files.