Day 12 of the @hertechtrail @HTTDataChallenge task is to calculate total sales and average order value by region using SUM(), AVG(), COUNT() and chained JOINs across 4 tables. N/B I used ROUND() on your AVG() to reduce my decimal places. #SQLAggregation #DataAnalytics

I wrote a query calculating the total sales and average order value for each region where the papers are being sold; I had to join 4 different tables to get the result. Thread… #hertechtrailacademy #HTTDataChallenge #SQLAggregation #DataAnalytics @tech_bella @it_is_reel

Day 12 of 15-day Data challenge Today, I wrote an SQL query to calculate the Total sales and Average order value for each region. Grouping and aggregation are powerful tools for gaining insights from data. #HerTechTrailAcademy #HTTDataChallenge #SQLAggregation #DataAnalytics

Day 12 of my 15-Day #HTTDataChallenge Today, I dived into grouping and aggregation. My task was to write an SQL query to calculate the total sales and average order value by region. ✨Below is a snippet of my query and the results.👇 #SQLAggregation @hertechtrail @phaibooboo

Day 15 #20dayswithdata Joined multiple tables (Accounts, Salesrep, Orders, Region) to retrieve total orders and average order value by region. Results show that Northeast and Southeast region were highest grossing. #SQLAggregation #DataAnalytics #MySQL

Day 15 of 20 Task: Write an SQL query to calculate total sales and average order value by region. #hertechtrailacademy #HTTDataChallenge #20dayswithdata #SQLAggregation #DataAnalytics

helping us identify high-value customers and potential areas for revenue growth. #hertechtrailacademy #SQLhavingclause #SQLaggregation #buildinpublic @ @phaibooboo @fresh_gb @FrizzyHub @zulaykha_o

Day 15 SQL Query to calculate total sales and average sales by city. I have to come back to this because I have not gotten the proper hang of it. #20dayswithdata #SQLAggregation #DataAnalytics

Day 15 Grouping and Aggregation Write an SQL query to calculate total sales and average value by region #20dayswithdata #hertechtrailacademy #httdatachallenge #sqlaggregation #dataanalytics @phaibooboo @ImaNjokko @AtiJoshua @fresh_gb @hertechtrail @fresh_gb @OMOTOSHOOLAMI15

Day 15. The North Eastern Region made the highest overall sales in both paper quantity sold (1,230,378 paper units sold) and total revenue generated ($7,744,405.36), while the Mid Western region recorded the lowest in sales in both categories, when compared to all the other regions. The Western region, which was the second least performing region in terms of total sales quantity and total sales amount, was observed to have the highest average order value ($6.39) compared to all other regions. The Western region had the highest average sales quantity and average sales amount. #20dayswithdata #SQLAggregation #DataAnalytics

DAY 15 - GROUPING AND AGGREGATION #20dayswithdata #hertechtrailacademy #HTTDatachallenge #SQLAggregation #DataAnalytics Wrote an SQL query to calculate Total sales and average order value by region.

Day 15 The task is to  write an SQL query to calculate total sales and average order value by region. To be able to do this I joined order, account, sales rep and region table together. #20dayswithdata #hertechtrailacademy #HTTDataChallenge #SQLAggregation #DataAnalytics

DAY 15: Grouping and Aggregation I joined 4 tables in this exercise to calculate the total sales and average orders recorded by each of the 4 regions in the Parch & Posey database. @phaibooboo #20dayswithdata #hertechtrailacademy #HTTDataChallenge #SQLAggregation #DataAnalytics.

Day15 #20dayswithdata Wrote an SQL query to calculate total sales and average order value by region. #SQLAggregation #DataAnalytics.

Day 15: Calculating total sales and average order by region. I performed join on orders, accounts, sales_reps and region tables #20dayswithdata #SQLAggregation #DataAnalytics @hertechtrail @phaibooboo @ImaNjokko @fresh_gb @AtiJoshua @vicSomadina @OMOTOSHOOLAMI15

Day 15: Grouping and Aggregation I wrote an SQL query to calculate total sales and average order value by region @hertechtrail @PromiseNonso_ @vicSomadina @phaibooboo @ImaNjokko @fresh_gb #20dayswithdata #hertechtrailacademy #HTTDataChallenge #SQLAggregation #DataAnalytics

tables using their primary key in order to achieve the result of the query. #hertechtrailacademy #HTTDataChallenge @hertechtrail @phaibooboo , @ImaNjokko , @fresh_gb , @vicSomadina , @AtiJoshua , @OMOTOSHOOLAMI15 #SQLAggregation #DataAnalytics

Day 15: Grouping and Aggregation An SQL query to calculate total sales and average orders by each region. It was achieved by joining 3 tables. #20dayswithdata #SQLAggregation #DataAnalytics.

Day 15. Today, we aggregate data to generate insights. Lets goooooo!!! You can use the hashtags #20dayswithdata #SQLAggregation #DataAnalytics.