Detailed view of the collage

SQL query to fetch detailed information about the collage and branch
selected. The collected information is then stored as a JSON.