Segun fasanya @simplyselected

“Data Geek | Data Analyst | Finance Fan | Simplifying money moves" Joined July 2025

Tweets

1K
Followers

284
Following

220
Likes

2K

Segun fasanya @simplyselected

6 hours ago

@ojuolape124 Sabi girl

0 0 0 10 0

View Details

Tomorrow is Day 120. The last day of the challenge and the last day of the SQL Sprint. I'll be sharing everything, every concept learned, every mistake made, and what comes next. See you at the finish line. 🏁 #SQLSprint #SQL #120DayChallenge #LearningInPublic

0 0 0 2 0

View Details

Segun fasanya @simplyselected

10 hours ago

RANK() OVER (ORDER BY salaryDESC) AS company_rank FROM employees 26 days ago I couldn't write any of those queries. Today I wrote all 5 on a real dataset using nothing but what the SQL Sprint taught. SELECT, WHERE, GROUP BY, HAVING, JOIN, Subquery, CTE, CASE WHEN, Window

1 0 0 2 0

View Details

Segun fasanya @simplyselected

10 hours ago

Day 119/120✅ SQL Sprint Day 26. One day from the finish line with no new concept today. Today I used everything the sprint taught me on a real dataset. 5 business questions, 5 SQL queries with real answers. Here's the full breakdown. 🧵 #120DayChallenge #SQLSprint

1 0 4 47 0

View Details

Segun fasanya @simplyselected

a day ago

Day 25 challenge: Write a query that shows each employee's name, salary, and their department's average salary side by side. Use: AVG() OVER (PARTITION BY department) Drop your query below 👇 #SQL #LearnSQL #DataAnalytics

0 0 0 4 0

View Details

Segun fasanya @simplyselected

a day ago

The three most common window functions: SUM() OVER() → running totals AVG() OVER() → group averages per row RANK() OVER() → ranking within a partition

1 0 0 6 0

View Details

Segun fasanya @simplyselected

a day ago

Day 118/120✅ SQL Sprint Day 25 Today: Window Functions — the concept that separates beginner SQL from analyst SQL. Thread 🧵 #SQLSprint #120DaysOfBuildingInPublic

1 0 2 54 1

View Details

Segun fasanya @simplyselected

2 days ago

Happy Birthday 🎈🎁🎊🎉🎂 Darling Your new Age is blessed 🥹

Fatimah Ojuolape @ojuolape124

2 days ago

Happy birthday to me🥰🥰 Two days ago, I said I will be gifting myself by giving out today… It’s only 5 people that can win my gift 🎁 Stay tuned… I will share it in the evening

5 0 8 204 0

0 0 1 59 0

View Details

Segun fasanya @simplyselected

2 days ago

Sprint Day 24 challenge: Write a CASE WHEN that segments customers into 3 tiers based on their total spend: → 'Premium' if spend > 100,000 → 'Regular' if spend between 30,000 and 100,000 → 'Occasional' otherwise Add it as a column called customer_tier. #SQLSprint

0 0 0 8 0

View Details

Segun fasanya @simplyselected

2 days ago

One rule that saves you from wrong results: SQL checks WHEN conditions top to bottom and stops at the first match. Order matters so put your most specific conditions first and put your broadest ELSE last. WHEN salary > 800000 → specific ✓ ELSE → catches everything else

1 0 0 10 0

View Details

Segun fasanya @simplyselected

2 days ago

Day 117/120✅ SQL Sprint Day 24. Today's lesson is the one that makes non-technical people stop and say "SQL can do THAT?" CASE WHEN — SQL's built-in if/else logic. Turn raw numbers into labels. Here's how. 🧵 #120DayChallenge #SQLSprint