what statement(s) is correct

[ballouta]

Hello

Kindly help me in this, I want to know what statements are correct in MySQL.

 

    A.  SELECT state, sum(sales) sum_sales FROM sales WHERE sum_sales > 100 GROUP BY state.

    B.  SELECT state, sum(sales) sum_sales FROM sales HAVING sum(sales) > 100 GROUP BY state.

    C.  SELECT state, sum(sales) sum_sales FROM sales WHERE sum(sales) > 100 GROUP BY state

 

Thank you so much

[The Little Guy]

None, I would do this:

SELECT state, sum(sales) as sum_sales FROM sales GROUP BY state HAVING  sum_sales > 100

 

A and B gives an error

B The group by comes before the having

C and B your doing the sum twice

[ballouta]

Thank You so much

[fenway]

You can't use an aggregate expression in WHERE, only HAVING.

[ballouta]

Thank You all.