GROUP BY and HAVING CLAUSE IN SQL: SQL 30 Day Challenge Day 12

[@developbit]

I need to practice more on the having clause😄

[@malcorub]

8:00 my experience with PostGre and SQL Server is that you cannot use the newly created alias in the WHERE or HAVING of the same Select statement. I guess SQL Lite is different in that respect.

[@learningwithjelly]

Yes could be a difference based on the SQL tool different dialect...thanks for sharing your experience