SQL Store Sales Analysis from Transactions

do not ask more than $100
use Oracle PL SQL
teach me how to free install on my local windows 11
you have 2 days to do
use SQL to calculate per day summary for each day for each product for each store for 3 years
suggest your columns
also more needed columns will be provided


simulate tables with store transactions
take to account
- promotions
-store location
-state
-usa holydays

simulate lookup tables for
1 promotion
2 store locations
3 prices changes each 3 months
etc

at least data simulation may be done in python and then upload to SQL DB (but better in SQL)
you provide both sql and python code
data for 3 years
100 proudects
20 stores
5 usa stsates
randomly 30 to 170 transactions per day for given product for usual price
randomly 200 to 600 transactions per day for given product for usual promotion



aceptance: all work on my computer