use MyBusiness;

db.createCollection("SalesByCategory");
db.SalesByCategory.insert({ "_id": 1, "Category": "MongoDB Podcast", "Description": "Covers NoSQL Queries", "Price": 19.99, "Sales": 50 } );
db.SalesByCategory.insert({ "_id": 2, "Category": "Visualization Podcast", "Description": "Examines Common Visualizations", "Price": 29.99, "Sales": 30 } );
db.SalesByCategory.insert({ "_id": 3, "Category": "MySQL Podcast", "Description": "Common Query Operations", "Price": 39.99, "Sales": 20 } );

db.createCollection("Sales");
db.Sales.insert( { "_id": 1, "SalesPerson": 101,  "Region": "West", "CustomerID": 401, "ProductID": 1, "Total": 19.99, "SaleDate": "12-01-2020" } );
db.Sales.insert( { "_id": 2, "SalesPerson": 102,  "Region": "West", "CustomerID": 403, "ProductID": 2, "Total": 29.99, "SaleDate": "11-01-2020" } );
db.Sales.insert( { "_id": 3, "SalesPerson": 103,  "Region": "West", "CustomerID": 403, "ProductID": 3,  "Total": 39.99, "SaleDate": "10-01-2020" } );
db.Sales.insert( { "_id": 4, "SalesPerson": 104,  "Region": "West", "CustomerID": 401, "ProductID": 4,  "Total": 49.99, "SaleDate": "09-01-2020" } );
	