Need to have a few views and queries created for the attached database structure. The DDL and DML is included to create the database tables and fill with data. This is a distributed database, so needs 2 separate databases created and the views/queries will be created based on this.