select tipom.tipom,count(prestamos.nrenovaciones) from prestamos, items ,tipom where items.id=prestamos.id_item and items.ntipom=tipom.ntipom and prestamos.fecprestamo>='20111001' and prestamos.fecprestamo<='20111031' group by tipom.tipom order by tipom.tipom select tipom.tipom,count(devolucion.nrenovaciones) from devolucion ,items ,tipom where items.id=devolucion.id_item and items.ntipom=tipom.ntipom and devolucion.fecprestamo>='20111001' and devolucion.fecdevolucion<='20111031' group by tipom.tipom order by tipom.tipom;