Quick Finance SQL Queries

I have a small finance-class assignment that boils down to writing a few clean, well-commented SQL queries. The tables already exist—my professor just wants to see how the data can be retrieved and analyzed. Specifically, I need to pull information from a financial-transactions table, then:

• Summarize totals (e.g., overall spending, category totals)
• Filter the results by date ranges and/or amount thresholds
• Join the transactions with one or two related tables that I’ll provide

The instructions are step-by-step and very straightforward; the whole task should take no more than half an hour if you’re comfortable with basic SELECT statements, GROUP BY, HAVING, and simple JOINs. I’ll send you the schema and the professor’s exact wording as soon as we start so you can mirror it precisely.

Deliverables
1. A single .sql file containing the required queries, each clearly labeled and commented.
2. A brief text or markdown file (a few lines is fine) explaining how to run the script and what each query returns.

Acceptance criteria: all queries execute without modification on my provided dataset (standard ANSI SQL) and return the expected results outlined in the instructions.

Turnaround: 24 hours from contract start—earlier is even better.