A simple class project of database design.
SKU design is complete and supports both sales and returns in fifo order.
cogs for sales will be the cost of items that first entered the inventory.
cogs for returns will be the cost assigned to item that is most recent to the sales date.
Various procedures and functions for different purposes. See comments for details.
Run sql files from 1 to 6 as some procedures have dependency.