inango

@hertechtrail What the query involved: 4 tables joined (orders, accounts, sales_reps, region) COUNT, SUM, AVG, MAX aggregations Window function (PARTITION BY) to calculate each rep’s % share of regional sales Filtered and sorted by region and performance

Day 15 of @hertechtrail #HTTDataChallenge Problem I tackled: “Which sales reps are driving the most revenue in each region and what % of their region’s total sales do they own?” This is just the beginning. #AdvancedSQLChallenge #DataAnalytics

@virtuousii Na to hide oh😂😂😂

My thing is, Chike also has an older brother.

You people cheat a lot mehn Man cheat Woman cheat Employer cheat Employee cheat Government cheat us 🫠

What a day to be alive!!🔥☄️

Dai Dai is here. The @FIFAWorldCup 2026 starts now! @burnaboy songwhip.com/shakira/dai-dai

@blessinguzzi @Officialchike Boo of the Booless should come let’s watch COML in Abuja together o

Watch Call Of My Life with the boo of the booless @Officialchike . Come with your boo and if you are booless, still come! #COML

I used CASE WHEN to automatically categorize each channel: > $5000000→ High Value $1000000–$5000000 → Medium Value < $1000000 → Low Value

Whelp☹️... Day 14 of @hertechtrail #HTTDataChallenge task is to retrieve the total sales for each channel from which clients access the company. Highlight high value and low value channels. #SQLJoinAggregations #DataIntegration

I started the year without any concrete plans to be honest but then I got admitted into a Nigerian university to do my masters. As I round up my first semester, I’m here to say that there is hope for the Nigerian Education System. With the right structure of course… 🫠🫶🏾

Subquery purpose: The inner query (SELECT AVG...) runs first and returns the average order value. The outer query then uses that number to filter and return only customers whose orders exceed it. A query inside a query.... interesting!!

Day 13 of @hertechtrail #HTTDataChallenge task: find customers who have made orders above the average order value. @phaibooboo @it_is_reel @precy_oma @Ogbonna42449096 @AtiJoshua #SQLSubqueries #DataAnalysis

@AndyjnrUmaru A phone... this laptop has tried for me😞

Please Mention an item you want so badly but, due to funds, you can't afford it. Someone might surprise you today in the comments. A closed mouth is a closed destiny. 🤲🏾🤷‍♀️🥺

@theladymotara Amen As I prepare for my exam.. I read and I understand completely 🙏

Something Good Will Happen To You Today.

04:12 Na wa💔😔

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

@theladymotara Anything for Mrs Mo🥹

Goodmorning, Please Subscribe to my youtube channel. Thank you. @renzandmo" target="_blank" rel="nofollow noopener">youtube.com/@renzandmo

@Geraldyne_25 @hertechtrail Sabiiii girl😍

If you can't link customers to revenue, you're flying blind. Today: Data Integration using SQL JOINS to bridge the 'Accounts' & 'Orders' tables. Result: 6,912 transactions mapped to names/POCs. Day11 of #HTTDataChallenge @hertechtrail #FMCGNigeria #SQL #DataAnalysis

Day 10 of the @hertechtrail #HTTDataChallenge is to join two tables and retrieve 3 columns each from them I joined accounts and orders table, and retrieved 3 columns each using SQL query. #SQLJoining #DataIntegration

@Adhekunbi Videogenic like mad

Are you Photogenic or Videogenic?