Why we obtained 101 rows from 'from salaries' and 807 from 'from employees.salaries'. Whats the difference? Also, in the same example why's that we can write "WHERE salary > 120000" to obtain 807 rows result but ony 11 rows for "HAVING salary > 120000" ? Thanks.

Hi Angela!Thanks for reaching out. These two queries were provided for discussion, to emphasize the difference between using WHERE and HAVING. When using WHERE instead of HAVING, the output is larger because in the output we include individual contracts higher than $120,000 per year. The output does not contain average salary values. In other words, you take all rows for which the salary is higher than $120,000 per year, and then you take the average of each single row. Of course, this produces the same value. Hope this helps.Best,Tsvetelin

Follow this topic

Angela Zhang

Last answered:

13 Mar 2023

Posted on:

12 Mar 2023

excercise question

in SQL / HAVING

1 answers ( 0 marked as helpful)

Tsvetelin Tsonkov

Instructor

Posted on:

13 Mar 2023

excercise question

Submit an answer

related questions