Query SELECT COUNT(id) AS num_ventas,sucursal FROM empresa.ventas GROUP BY sucursal, Sat Nov 22 22:28:21 2008