<html>
<head>
<script type="text/javascript" src="https://www.google.c...sapi"></script>
<script type="text/javascript">
google.load("visualization", "1", {packages: ["corechart"]});
google.setOnLoadCallback(drawChart);
function drawChart() {
var data = google.visualization.arrayToDataTable([
['Cargo', 'Activos', 'Retirados'],
['2004', 1000, 400],
['2005', 1170, 460],
['2006', 660, 1120],
['2007', 1030, 540]
]);
var options = {
title: 'Company Performance',
hAxis: {title: 'Year', titleTextStyle: {color: 'red'}},
legend: {position: 'bottom', textStyle: {color: 'blue', fontSize: 13}},
width: 900,
height: 500
};
var chart = new google.visualization.ColumnChart(document.getElementById('chart_div'));
chart.draw(data, options);
}
</script>
</head>
<body>
<div id="chart_div" style="width: 900px; height: 500px;"></div>
</body>
</html>
SELECT b.nombre as cargo,c.nombre as estado,count(a.tipo) as numero FROM 160_participantes AS a left JOIN 160_tipo AS b ON a.tipo = b.id inner join 160_estado as c on a.estado = c.id group by b.nombre,a.estado
mil gracias de antemanno por la ayuda