SQL Query Assistance - Transaction History

I'm searching for an experienced SQL specialist to assist me in creating a query. The task will involve pulling specific data from the transactional history within our database. The critical detail that we need to extract is the transaction amount. Proficiency in writing SQL queries and a solid understanding of transactional databases is essential for this job. This may seem like a 5-minute task for the experienced, however, should you deliver to satisfaction, there are several more queries that need to be written out. Get in touch if you can create a precise, optimized SQL query to extract transactional amounts from our database.
• Skills/Experience:
- SQL proficiency
- Experience working with transactional databases
- Detail-orientated
- Strong problem-solving abilities

I need a query that will give me total sales within a period within this data dictionary

https://help.reasonautomation.com/vendor/open-and-confirmed-purchase-orders