SELECT 
 ia.id, 
 COUNT(ia.invoice_id) AS total_de_facturas,
 SUM(CASE WHEN ia.invoice_amount <> 0 
          THEN ia.invoice_amount
          ELSE ia.base_amount END) AS monto_total,
 ia.currency_code AS tipo_de_moneda,
 MIN(ia.invoice_date) AS Primer_factura, 
 MAX(ia.invoice_date) AS ultima_factura
 FROM invoices_all ia
 GROUP BY ia.id, ia.currency_code
 ORDER BY total_de_facturas DESC;

把钱放在箱子外面的时候应该行得通。

SELECT IA.ID,
         COUNT (IA.INVOICE_ID) TOTAL_DE_FACTURAS,
         SUM (
            CASE
               WHEN IA.INVOICE_AMOUNT <> 0 THEN IA.INVOICE_AMOUNT
               ELSE IA.BASE_AMOUNT
            END)
            MONTO_TOTAL,
         IA.CURRENCY_CODE TIPO_DE_MONEDA,
         MIN (IA.INVOICE_DATE) PRIMER_FACTURA,
         MAX (IA.INVOICE_DATE) ULTIMA_FACTURA
    FROM INVOICES_ALL IA
GROUP BY IA.ID, IA.CURRENCY_CODE
ORDER BY TOTAL_DE_FACTURAS DESC;

如果您碰巧需要sum（ia.invoice\u amount）比较，那么您应该首先在下面的子查询中求和。

SELECT IA.ID,
         COUNT (IA.INVOICE_ID) TOTAL_DE_FACTURAS,
         SUM (
            CASE
               WHEN IA.SUMMED_INVOICE_AMOUNT <> 0 THEN IA.SUMMED_INVOICE_AMOUNT
               ELSE IA.BASE_AMOUNT
            END)
            MONTO_TOTAL,
         IA.CURRENCY_CODE TIPO_DE_MONEDA,
         MIN (IA.INVOICE_DATE) PRIMER_FACTURA,
         MAX (IA.INVOICE_DATE) ULTIMA_FACTURA
    FROM (  SELECT 
                  SUM (INVOICE_AMOUNT) AS SUMMED_INVOICE_AMOUNT,
                   INVOICE_DATE,
                   CURRENCY_CODE,
                   INVOICE_ID,
                   ID,
                   BASE_AMOUNT
              FROM INVOICES_ALL IA
          GROUP BY INVOICE_DATE,
                   CURRENCY_CODE,
                   INVOICE_ID,
                   ID,
                   BASE_AMOUNT) IA
GROUP BY IA.ID, IA.CURRENCY_CODE
ORDER BY TOTAL_DE_FACTURAS DESC;