FIFO LIFO AVERAGE COST OF GOODS SOLD CALCULATION SQL

This is only a SQL Database design and formula to arrive at cost of goods sold (COGS) in SQL (PLEASE REFER TO ATTACHED FILE). I am looking for someone who has already implemented such formula in SQL

Attached herewith is the excel file that shows the cost of goods sold either via FIFO, LIFO or average price method. I want someone to work out the same excel file in SQL.

Also note, the excel file shows only 1 product but our system will have multiple product and system should look at product id to work out the FIFO, LIFO & Average cost of goods sold

BELOW LINK just explain a bit but not all as per my requirment for all product of the business:

[login to view URL]

Pemrograman Database MySQL SQL

ID Proyek: #6710660

Tentang proyek