sql for material transaction report

Content

i need to create a material transaction report between 2 dates

the first i need open balance quantity (sum quantity before the first date)

transaction between 2 dates with unit cost for each transaction

end balance and cost.