Page History

<script>
$(document).ready(function() {
    //Declare the eChart
	var theChart = echarts.init(document.getElementById([ID HERE]));
    });

	//Redirect after click
    someCharttheChart.on('click', function(params) {
      	url = [OTHER CHART'S URL LINK] + "?" + params.name;
      	document.location.href = url;
    });
});
</script>

SELECT
	a.c_email as "Email",
	COUNT(a.c_email) as "Amount"
FROM
	app_fd_book_meeting_room a
JOIN
	app_fd_create_meeting_room b
ON
	a.c_room_id = b.id
WHERE
	b.c_room_ID = "#request.queryString#" and 
	a.c_status = "accept"
GROUP BY
	a.c_email, b.c_room_id