sql query to fetch list of collages

and return it as a json