usando INNER JOIN, WHERE, GROUP BY, COUNT Y SUM