列的MySql Group By和Sum总值，以min值显示

Question

I have two questions:

1. How to group and sum a column.
2. How to displayed the result with a min sum value

I got my 1st answer here on how to group and sum the column, but I need to filter out by min amount of 100 ..

I tried

SELECT 
    member_code, SUM(product_price) as totalSales
FROM 
    src_calculation_daily
WHERE 
    totalSales > 100
GROUP BY 
    member_code

Any help is much appreciated. Thank you

Answer 1

I think you just want a HAVING clause:

SELECT member_code, sum(product_price) as totalSales
FROM src_calculation_daily
GROUP BY member_code
HAVING totalSales > 100;