How would you combine data from multiple transactional tables accurately using complex joins and subqueries?
