Write a complex SQL query to retrieve specific transaction logs from a simulated security database, including joins and filtering at Protegrity Usa.
