Rosie | Data+Writing
@rosiecreator
Followers
625
Following
619
Media
72
Statuses
3,044
Data Analyst • Content & Technical Writer • I geek out over skincare, beauty, movies, and books • Always ready to dive into a good conversation✨
Nigeria
Joined October 2019
Don't wanna be here?
Send us removal request.
Explore trending content on Musk Viewer
Chicago
• 686298 Tweets
ليستر
• 260715 Tweets
توتنهام
• 259786 Tweets
فياريال
• 259526 Tweets
#FilistiniUnutma
• 54439 Tweets
Leicester
• 46243 Tweets
Phil Donahue
• 44720 Tweets
Tottenham
• 33731 Tweets
Spurs
• 33055 Tweets
Secretaría
• 33053 Tweets
LONG LIVE
• 33018 Tweets
Vardy
• 30479 Tweets
Julius Malema
• 27229 Tweets
LIBERTÁ IS COMING
• 24740 Tweets
Cueva
• 17592 Tweets
George Santos
• 15148 Tweets
Villarreal
• 14571 Tweets
#LEITOT
• 13574 Tweets
#الصلاحيات_للمهيدب_مطلبنا
• 12733 Tweets
THE ARCHER
• 11497 Tweets
#JuveComo
• 11003 Tweets
Pinned Tweet
I created these notes today while solving
#Sql
projects and challenges!
Honestly, if I had to learn
#SqlJoins
all over again, I’d want to start with a note like this which is why I created this to help anyone who is struggling with joins!
What do you think?
#DataAnalytics
14
47
218
My
#DataAnalytics
personal study goal for the week is this SQL checklist that I put together.
Since Monday, I have been on my learning board to study and revise
#Sql
as well as challenge myself intensely.
Can you boast of anything here?
17
21
184
#AggregateFunctions
are my private detectives when it comes to solving problems in SQL and I'm so glad that on today's episode of the
#RedPenOnA4Paper
with Rosie series, I get to highlight the most commonly used aggregate functions in
#Sql
Memorize them 👀👀
3
21
105
‘USING GROUP BY WITH AGGREGATE FUNCTIONS’
I don't just have Private Detectives
#AggregateFunctions
I have a matchmaker too and her name is the
#GroupBy
clause!!!
#RedPenOnA4Paper
by Rosie series is presenting an episode on grouping!!
2
8
76
Introducing the
#RedPenOnA4Paper
series by Rosie.
This series is part of my
#DataAnalysis
documentation where I create easy-to-understand study notes for anyone in the
#DataAnalytics
space.
Today's note : Introduction to
#SubQueries
in
#Sql
🖍️💻
5
13
75
Hi! I am Rosemary John. I am a creative, a content writer with an enthralling effect. I don’t just write, I create and leave my words swimming in the soul of my readers.
To find out more about my services, do well to click the link:
4
19
66
A few weeks ago, I ended a
#DataAnalytics
training
@malhubng
and the experience was fulfilling in a way that fueled my curiosity about data even more. My outstanding instructors were
@ibn_wittig
and
@MariamJaiyeola_
I'm part of the
#DataCommunity
and my impact will be felt.
8
15
68
‘INTRODUCTION TO CTEs(Common Table Expression)’
#RedPenOnA4Paper
by Rosie is introducing you to
#CTEs
I am happy about this one because the example discussed here is a combination of aggregate functions, group by, joins, and subqueries (everything we have discussed lately😉)
4
11
63
On today’s episode of the
#RedPenOnA4Paper
series by Rosie, let us discuss ‘WHERE vs HAVING’….
The
#GroupBy
clause isn't always going to get you what you're looking for, so what happens if you need further help filtering on aggregated data? Or maybe not? Hmm🤔
2
12
61
The
#RedPenOnA4Paper
series by Rosie is back this week and we’re all going to be breaking through windows
#dataFam
How?🤔
By ‘Understanding Window Functions’
If I had to start learning
#WindowFunctions
again, I would appreciate being shown a note like this!!!
6
9
51
On today's episode of the
#RedPenOnA4Paper
series by Rosie, we are breaking through the window again and I'm especially proud of this note.
‘UNDERSTANDING WINDOW FUNCTIONS III’ + ‘COMMON AGGREGATE WINDOW FUNCTIONS’
There's an exercise for you to try💪
#Data
1
9
42
On today’s
#RedPenOnA4Paper
series by Rosie, we are finally breaking in through the window and we’ll definitely keep doing that this week😅
#DataFam
‘Understanding Window Functions II’
I want to believe you read the first note on Window Functions!!!👀👀
#DataAnalytics
2
2
36
There's an intrinsic joy that comes from knowing that someone was impacted by something you put out.
#RedPenOnA4Paper
note did this and I am happy that so far, documenting my studies has proven useful in people's journey with data.
#DataAnalytics
#Sql
#DataFam
2
4
32
On today’s episode of the
#RedPenOnA4Paper
series by Rosie, I created easy-to-understand study notes on ‘
#CorrelatedSubqueries
’ just as I promised I would.
What is a Correlated Subquery?💻🖍️
What makes it different from the other subqueries?
#DataAnalytics
👇 👇 👇
Introducing the
#RedPenOnA4Paper
series by Rosie.
This series is part of my
#DataAnalysis
documentation where I create easy-to-understand study notes for anyone in the
#DataAnalytics
space.
Today's note : Introduction to
#SubQueries
in
#Sql
🖍️💻
5
13
75
1
6
31
Real-world scenarios Where Aggregate Functions Can be Utilized for Practical Insights:
🖍️Calculating total sales over a specific period to assess financial performance.
🖍️An e-commerce platform wants to showcase the average rating of products based on customer reviews.
4
3
29
I am so proud of my recent
#RedPenOnA4Paper
note on Window Functions. So proud of myself because it took sitting back to study over and over + trying out different tasks + discipline to get the note out!!
Teaching in the simplest way is truly a gift!
#DataAnalytics
On today's episode of the
#RedPenOnA4Paper
series by Rosie, we are breaking through the window again and I'm especially proud of this note.
‘UNDERSTANDING WINDOW FUNCTIONS III’ + ‘COMMON AGGREGATE WINDOW FUNCTIONS’
There's an exercise for you to try💪
#Data
1
9
42
1
2
28
Just realized that I haven't created notes on Aggregate Functions. I definitely will🤝
CTEs will be coming up too so stay tuned😉
#DataAnalytics
#Data
#Sql
1
5
28
I guess this is going to be the written version of bloopers for
#RedPenOnA4Paper
lol…
I realized that I made a huge mistake in my query here but I'm glad I spotted it out immediately…
Let’s have some fun😄
If I want to maintain the query, what will change in my result?
2
2
27
This meeting with
@tech_queen
organized by
@Digitaleydrive
and anchored by
@Roshethequeen
was one of the best ways I spent my evening yesterday as someone who is intentionally looking to step into the global scene.
Did I learn how to position myself better? Well YES!!
2
3
24
I guess this is important to highlight because it will certainly matter in your understanding of ‘Window Functions’
Very important!
Check out our note on ‘Understanding Window Functions’
#RedPenOnA4Paper
#Sql
#WindowFunctions
#DataFam
#DataCommunity
The
#RedPenOnA4Paper
series by Rosie is back this week and we’re all going to be breaking through windows
#dataFam
How?🤔
By ‘Understanding Window Functions’
If I had to start learning
#WindowFunctions
again, I would appreciate being shown a note like this!!!
6
9
51
0
5
23
If you cannot solve this after reading my
#RedPenOnA4Paper
notes on ‘AGGREGATE FUNCTIONS’ and ‘USING GROUP BY WITH AGGREGATE FUNCTIONS’ just know that we will fight😭👀👀
#SQL
Interview Question for
#DataScience
:
A company has provided sales data containing information about customer purchases, as shown in the table below.
Your task is to:
Calculate Total Revenue
Calculate Total Sales by Product
Find Top Customers by Revenue
Learn to solve it
6
82
426
4
2
23
The end of an era🥲
0
2
21
“Dear friends,
let's not just say we love with words,
but show our love in what we do
and how we
demonstrate the truth.”❤️
0
8
20
My LinkedIn community has been having fun with the
#RedPenOnA4Paper
series and this comment cracked me up real good 😂🤣
#DataAnalytics
#Data
#Sql
#DataFam
👇👇👇👇check out the tweet I linked below to get the gist😁
‘USING GROUP BY WITH AGGREGATE FUNCTIONS’
I don't just have Private Detectives
#AggregateFunctions
I have a matchmaker too and her name is the
#GroupBy
clause!!!
#RedPenOnA4Paper
by Rosie series is presenting an episode on grouping!!
2
8
76
1
1
21
This is one of my favorite learning techniques and so far in my
#DataAnalytics
journey, my mode of transmitting (step 5) information is what I have been doing with the
#RedPenOnA4Paper
note!
Share your learning technique with me. I am curious 🤔👀
#DataFam
0
6
19
Several people have told me to create notes on Window Functions and I promise that I'm doing just that👀💃
#DataFam
#DataAnalytics
We are going to have FUN this week😅
2
3
19
Just solved this Advertiser Status[Facebook SQL Interview Question] from DataLemur and it felt like a lot at first glance. But I promise it was fun😂🤣!!
How would you approach solving a problem like this? Immediately I saw two tables, I just screamed ‘JOINS’😂
2
2
18
My laptop has been acting up🥲
God please 🥲🥲
How’s everyone doing this week?
Can’t wait to be fully back 🥹
6
1
17
I think I need to post more practice questions on ‘Grouping’ because I love these conversations🫶
Let us interact, ask questions, and be curious together! ‘Why this’, ‘Why that’, ‘Why not this’, ‘How about this’, ‘Is this better’!
Friendly SQL banter🏃♀️➡️
#Data
1
1
16
Hi guys. I picked up my pen today and I am delighted to share this article with you because it marks the start of my contribution to the world of analytics.
5
9
16
The
#RedPenOnA4Paper
series by Rosie was on a mission this week and I can be sure that mission wasn't a failure if you can tick at least three of these boxes👀!!!
What was your favorite note this week?
As for me, I had so much fun with my private detectives😜
#DataAnalytics
2
2
16
Hey! I don’t mean to brag but there’s something so smoothing and thrilling about the way I write. I spit out fascinating content so effortlessly.
You’re not exactly going to find someone who writes as great as ROSEMARY JOHN.
Check out this link;
0
4
15
Sometimes, I imagine my tears kissing the soil of the earth hoping that it understands pain enough to bury the burden.. But I also imagine that it’s root will find my tears a burden💔
#poetry
#WritingCommunity
#poetrylovers
#rosetherics_art
#poetrycommunity
2
5
14
I BELONG ON HIGH STREET POSTERS ACROSS THE ENTIRE UNIVERSE!!!!🦋
0
1
15
We will resume our
#RedPenOnA4Paper
easy-to-understand notes on Monday💃
Let's work on challenging ourselves with SQL projects and challenges this weekend… Okay?
#Sql
#DataAnalytics
#DataFam
#Data
1
1
14
Few
#Sql
INTERVIEW QUESTIONS FROM DATACAMP
- What is a subquery?
-What types of SQL subqueries do you know?
-What types of joins do you know?
-What is the difference between nested and correlated subqueries?
If you've studied my notes, these questions are easy😭👀👀
0
1
14
Started sharing my skincare journey on Instagram a while back and I have decided to introduce this side of me to twitter today!!
So here we go! Remember to use your sunscreen. Always use sunscreen. As a dry skin girlie, these sunscreens are my fav😍
2
8
13
A few Questions on
#Sql
Window Functions inspired by the
#RedPenOnA4Paper
notes on Windowing so far….
1) Can you Query without Partitioning? Explain your reasons.
2) What happens when you use an ORDER BY in the OVER clause?
2
3
14
My observation from constantly studying and solving technical challenges in
#DataAnalytics
is that it has helped me build muscle memory.
There are connections between neurons in the brain that become more robust with practice so there's that
Let's keep practicing guys 💪👏
0
0
13
Slowly learning to romanticize my life and to be happy in the now💙
0
2
13
Let's talk about using ‘GROUP BY’ with ‘AGGREGATE FUNCTIONS’
Shall we?
#RedPenOnA4Paper
#DataAnalytics
#Data
2
1
13
‘Vs’ here represents a relationship shared between these operations and it is interesting when you figure it out🤔
-JOINS Vs SUBQUERY
-WHERE Vs HAVING
-NATURAL JOIN Vs INNER JOIN Vs CROSS JOIN
-DISTINCT Vs GROUP BY
-LEFT JOIN Vs ANTI-JOIN Vs SEMI-JOIN
0
2
13
When all you ever wrote about was centered on a muse that’s not yours anymore
It leaves a void in a writer’s mind
It crashes a writer’s imagination and no matter how much you try, writing becomes such a task..
Even writers go through a healing process...it’s so humbling🌙
0
4
11
Excerpt from studying ‘Window Functions’
Once you understand the concept of grouping and using aggregates in SQL, understanding window functions is easier to grasp.
#Sql
#DataAnalytics
#DataFam
🧵
1
1
11
There’s a lasting joy that thrives when a writer brings a character to life by the rhythm of her ink and pad
You could almost feel your heart beat to the very life that you can create with your imagination...
#poetrycommunity
#WritingCommunity
0
5
11
My A4 paper and red pen against the world!!! This might just be my thing 💁💁
0
2
11
Do you think I should continue creating easy-to-understand notes like this? Let me know😊
#RedPenOnA4Paper
6
0
11
Time is a good storyteller
The heart has a mind of its own
Humans weren't created to thrive in solitude
1
3
10
It doesn’t always have to end with “HAPPILY EVER AFTER” because what if that’s not the end? Perhaps it is safe to say that even with the worst ending when all seems burnt to painful ash in our story, there lies another chapter. A beautiful chapter waiting to be read 🌙
#poetry
1
2
10
I don’t think I’m powerful. I know I’m powerful. I don’t think I’m a warrior. My name embodies war. I am. I am. I am.
0
3
10
This litany of affirmations that I rub daily on my skin and pour in my heart will be for my sons to love the breathing in and out of kindness on a woman's body.
_RosemaryEkong
#poetry
0
3
9
1
5
9
You are a very wicked human being. Evil
Breaking news🔥🔥🔥: Meet Lateefa Abidoye, Zainab's mother, employed at Osun State University. They both enjoyed spending the Sugar daddy's money together. 😫
She’s 22 Twitter FBI Ilorin Mariam Cho Cho Cho Enugu Hijab Royz lexus My Queen
272
99
306
0
0
9
0
0
8
When I wanna escape all the chaos in this world, poetry is my safe place ....What’s poetry to you?????
1
2
8
It is called weakness when your emotions twirl to the beat of humanity. Yet in such weakness lies the greatest power of love ❤️ 💜🤍💛🧡💚💙🤎💕❣️💖💘
#Poetry_Planet
#POEMS
#poetrylovers
#rosthetics_art
0
2
8
I name October my month of supernatural access, undeniable manifestation, upsurge, speed and perfect breakthrough.
0
6
8
Can't wait to put out technical articles where I break down some of these concepts.
The comments from my last article on ‘A Brief and Fun Introduction to Data Analytics’ warmed my heart and there is so much more from where that came from🫶💁
My
#DataAnalytics
personal study goal for the week is this SQL checklist that I put together.
Since Monday, I have been on my learning board to study and revise
#Sql
as well as challenge myself intensely.
Can you boast of anything here?
17
21
184
2
0
8
DO YOU UNDERSTAND SQL JOINS?
#Joins
#DataAnalytics
TABLE 1:
1
1
1
1
1
null
null
TABLE 2:
1
1
1
2
null
Find the INNER, LEFT, RIGHT, FULL, NATURAL, and CROSS join🤔
4
1
8
This task is making me teary. I love this so much. Definitely buying Aquafina bottle water tomorrow 😭😭😭😭😩😩😩😻😻😻😻
#BBNaijaXAquafina
1
0
8
#Sql
Interview Question: Consider 2 tables, TABLE-A and TABLE-B, what will be the ROW COUNT for the result table:
If you do an INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN.
TABLE-A
1
1
1
1
TABLE-B
1
1
1
🤔
1
0
7
Our share of trials and tribulations make us
_Rosemary
0
1
7
I do not possess wealth but you love me like gold❣️
0
1
7
I've learned that when satan wants to distract you, he sends people into your life!
1
0
7
• Rows Between Vs Range Between
• Row Number() Vs Rank() Vs Dense_rank()
• Lead Vs Lag
We have work to do🙇
#RedPenOnA4Paper
#Sql
#Data
#DataAnalytics
0
0
7
Because this world is scary and humans are so unpredictable. I don’t want to feel alone here. God shields me and prayer is always a time of vulnerability, joy, tears, happiness, courage, hope, love, strength, and total surrender. It’s my healing piece.
Why Do You Pray?
Why can't you just go about your normal life and not pray?
Quote with one reason why you pray.
108
17
253
0
2
7
I’m jealous of the smile that cuts across your lips
#lockdown
#SundayThoughts
#poem
#TogetherAtHome
#poetsofinstagram
#Poetry_Planet
0
1
7
And if I shall continue to live,
I’d beg the God of the entire universe to give parts of my body and sync my existence with the sun, moon and stars so that every time it finds its way to your flesh and bones, you are never without nature’s feeling of my love❣️
0
3
7
I’d rather not say that a concept is ‘Hard’ or ‘Difficult’ for me to grasp. I just say it is ‘Interesting’ while somehow fighting for my life💁😂
But hard? No, please…
If you listen to neurologists, you'll understand why this is important.
0
0
7