试试这个：

SELECT 
    sku,
    count(sku) AS 'refund_QTY_Order'
FROM
    settlements_qty_test
WHERE (sku NOT LIKE '%loc%' AND sku NOT LIKE 'isc%' 
AND sku NOT LIKE 'trek%' 
AND sku IS NOT NULL AND LENGTH(sku) > 0 
AND transaction_type = 'Refund'AND amount_description = 'Principal' 
AND amount_type = 'ItemPrice')
GROUP BY SKU ORDER BY refund_QTY_Order ASC

如果只需要sku为“h-root-c”的记录，则：

SELECT 
        sku,
        count(sku) AS 'refund_QTY_Order'
    FROM
        settlements_qty_test
    WHERE (sku IS NOT NULL AND sku='H-ROOT-C' 
    AND transaction_type = 'Refund'AND amount_description = 'Principal' 
    AND amount_type = 'ItemPrice')
    GROUP BY SKU ORDER BY refund_QTY_Order ASC

您可以将其简化为：

SELECT sku
       sum( (transaction_type = 'Refund' AND
             amount_description = 'Principal' AND
             amount_type = 'ItemPrice'
            )
           ) AS refund_QTY_Order
FROM settlements_qty_test
WHERE sku NOT LIKE '%loc%' AND
      sku NOT LIKE 'isc%' AND
      sku NOT LIKE 'trek%' AND
      LENGTH(sku) > 0
GROUP BY SKU
ORDER BY refund_QTY_Order ASC;

与…的比较 NULL 是多余的。我把条件逻辑留在 SELECT 所以你会得到 0 价值观。