visualization_controller sql, intermediate