How would you handle subqueries in a complex institutional reporting problem at University of Texas at Austin?