Let us prepare retail tables to come up with the solution for the problem statement.
Ensure that we have required database and user for retail data. We might provide the database as part of our labs.
Create Tables using the script provided. You can either use
psql or SQL Alchemy.
Data shall be loaded using the script provided.
Run queries to validate we have data in all the 6 tables.
%sql SELECT * FROM customers LIMIT 10