Understanding HAVING and Aliases in PostgreSQL for Efficient Query Writing

How to Run Aggregate Functions on Grouped Records While Preserving Unique Values in SQL