select * from (SELECT cast (DATEPART("month", Fecha_Venta) as
CHAR (2)) + '/' + cast ( DATEPART("year", Fecha_Venta) as CHAR (4)) AS FIELD_1, sum(Venta_Efectivo+Venta_Tarjeta+Venta_Credito)
AS FIELD_2 FROM loans GROUP BY
cast (DATEPART("month", Fecha_Venta) as CHAR (2)) + '/' + cast (DATEPART("year", Fecha_Venta) as CHAR (4))) as TEMP
order by SUBSTRING(field_1, 4, 4),cast (ltrim(rtrim(SUBSTRING(field_1, 1, 2))) as integer)