Answer: Creating Views

/*Query to create view named SalesTransactionsByCategory
to show each sales transaction with the 
corresponding category by each employee every month*/
CREATE VIEW SalesTransactionsByCategory AS
SELECT      S.SalesID AS 'Sales ID', 
            E.EName AS 'Employee Name', 
            PC.CategoryName AS Category, 
            S.SalesAmount AS 'Sales Amount', 
            S.Month AS Month
FROM        Sales S
JOIN        ProductCategories PC ON S.CategoryID = PC.CategoryID
JOIN        Employees E ON S.EID = E.EID;
SELECT * FROM SalesTransactionsByCategory ORDER BY Category ASC;