Скачать или смотреть SQL : Using Filters with Aggregate Function

Video 8: This video shows how to use filter condition with aggregation function. We are having Orders table and was asked to find the Customers who did two or more orders on 2022 and three or more orders on 2023. In the brute force approach, we do the aggregation then do the filter and then find the count of customers. In the improved version, we do the aggregation and filter condition in one SQL and find the count of customers. This exercise is mainly to show how to use the WHERE condition and the importance of HAVING clause.

code: https://github.com/jeganpillai/sql_re...

Follow me on,
YouTube :    / @growwithdata  
Website : https://growwithdata.co/
LinkedIn :   / growwithdata  
Facebook :   / growwithdata.co  
twitter :   / growwithdata_co  
WhatsApp : https://whatsapp.com/channel/0029VaF8...
Instagram :   / growwithdata.co  


#aggregations #aggregatefunction #havingclause #having #whereclause #where #filters #ctctable #derivedtable #sql #dataengineers #meta #google #facebook #apple #paypal #netflix #amazon #deinterview #sqlinterview #interviewquestions #leetcode #faang #maanga #mysql #oracle #dbms #query #sqlserver #mysql #coderpad #aggregates #aggregation #nonaggregation #database #placementpreparation