Complex SQL Query Builder Needed

I'm in need of a skilled SQL user who can promptly write me 2 complex SQL queries involving my transaction data.

Requirements:

- Familiarity with SQL
- Proficient at creating complex SQL queries

Involving Tables:

- Api_Transaction
- Api_user
- Api_ipaddress

I specifically require information from:

- Transaction amount
- Transaction date
- Customer details

If you are skilled at converting detailed requirements into complex SQL queries, this job is for you. Your advanced understanding of database management systems will be crucial for this task.