Intermediate SQL Tutorial | Having Clause

appreciate your effort

So short, yet so precise. Thank you Alex.

It’s almost like you don’t like Toby as much as Micheal

Commenting for traction as I continue learning, thanks as always for the videos!

Hi Alex,
Thanks for the great explaination.
When I run this :
select
jobTitle,
avg(Salary) as avg_salary
from
EmployeeSalary
group by 1
having avg(Salary) > 42000;
I get error "Each GROUP BY expression must contain at least one column that is not an outer reference."

But this works fine
select
jobTitle,
avg(Salary) as avg_salary
from
EmployeeSalary
group by JobTitle
having avg(Salary) > 42000;

Do you know why "group by 1" doesnt work here.

Thank you Alex!

realy amasing i love it

why should the having clause come above the order by claus in the average salary case

Alex, you're the real deal. Much love. Posterity willl definitely remember you

I’m getting HR as well with 50K average salary with the last query. Anybody else?

As I go through the contents. I am amazed and taking all these small steps at its strides. Thank you once again

Thank you Alex!

brilliant sir

I just have a question, can't we do HAVING count(JobTitle) even though we group by salary, isnt that possible? thank you

Yo! What did Michael do to Toby in this video?

Helpful and really good explanation

Can someone explain to me why

SELECT JobTitle, AVG(Salary) AS avgsalary

FROM EmployeeDemographics
JOIN EmployeeSalary
ON EmployeeDemographics.EmployeeID = EmployeeSalary.EmployeeID
GROUP BY JobTitle
HAVING avgsalary > 45000
ORDER BY avgsalary


is not working and I have to change the HAVING avgsalary > 45000 to HAVING AVG(Salary) > 45000?
I just wanted to try other methods if I could use HAVING clause with the column names and not the (Argument)

Great job! Thanks