This reflects my exact experience.
Data analysis is 30% tech, 70% business, and psychology.
Understand how problems are solved without tools first, even data itself is a tool.
Many drown in data and get buried by the tools.
In the end, it’s all about people and business.
#Analytics #DataScience
For example:
👉Why doesn’t a derived column’s alias work in the WHERE clause? Simple – the alias doesn’t exist yet because it’s created in the SELECT step, which happens after WHERE.
👉But it works in the ORDER BY clause because SELECT comes before ORDER BY.
When you know the order, debugging SQL becomes way easier!
The way I understand SQL’s order of execution is really simple:
1. FROM: It all starts here – this is where the data comes from.
2. ORDER BY: Sorting happens right before the final step.
3. LIMIT: This is the very last thing – it decides how many rows to return. 👇
Everything else happens between FROM and ORDER BY:
➡️JOIN: If you’re combining tables, that comes next.
➡️WHERE: Filtering comes early – it reduces rows in the process.
➡️GROUP BY: Used to group your data for calculations or summaries.
➡️HAVING: Filters aggregated data (only applies after GROUP BY).
➡️SELECT: This is where you pick the columns you need.
➡️DISTINCT: Removes duplicates from the selected data.
Once you understand this flow, many SQL details start making sense.
People don’t act because of data.
They act because they feel something.
You can show all the charts possible.
Still, emotions drive decisions.
“45% are malnourished” feels distant.
“Nearly half the people are malnourished” feels human.
Keep it simple. Make it human.
Food logistics
As a farmer, logistics has played a key role in siphoning funds (the devourer), yes we have bad roads but we are finding a way
1. Air cargo to 5 states (starts August)
2. Cold truck for 4 states
3. Now we add water ways
#FarmerSamson#ZeroHunger#FoodSecurity