Write a SQL query that uses subqueries to analyze a university reporting problem at the University of Pittsburgh.