25 Sep 2023
Day 18 of #20dayswithdata.
The snapshot below shows a list of customers with an average order value above the threshold (overall average order), which implies a good purchasing ability required for business to flourish.
#SQLHavingClause
#DataAggregation
ALT SQL query and results for customers with good purchasing ability.
2
58
DAY 18- AGGREGATING with HAVING
#20dayswithdata #hertechtrailacademy #HTTDatachallenge #SQLHavingClause
#DataAggregation
I calculated the average order value for each customer using the AVG () function then I used the HAVING clause to filter the results and only return rows
2
4
227
22 Sep 2023
DAY 18: AGGREGTING WITH HAVING
I used the having clause in an SQL query to calculate the average order value for each customer and filtered them with an average above five.
#20dayswithdata #SQLHAVINGCLAUSE #DataAggregation
1
3
103
22 Sep 2023
Day 18.
I generated the list of companies that have an average order rate above the overall average order rate.
This highlights the companies that have a better purchasing ability, compared to their counterparts.
#20dayswithdata #SQLHavingClause #DataAggregation
1
21
2,041
21 Sep 2023
helping us identify high-value customers and potential areas for revenue growth.
#hertechtrailacademy
#SQLhavingclause
#SQLaggregation #buildinpublic
@
@phaibooboo @fresh_gb @FrizzyHub @zulaykha_o
1
2
92
21 Sep 2023
Day 18
#20dayswithdata
Wrote an SQL query to calculate the average order value for each customer and filter those with an average above a certain amount.
#SQLHavingClause #DataAggregation.
2
64
21 Sep 2023
Day 18.
Today we focus on aggregation and filtration using the 'HAVING' clause.
Lets goooo!!!!!
You can use the hashtags #20dayswithdata #SQLHavingClause #DataAggregation
5
1,705
