If you want to learn patience, don't look elsewhere, just use the @duolingo free version 😭. The ads will humble you.
English
Iyanuoluwaposimi
141 posts
Iyanuoluwaposimi
@Analyst_Iyanu
Finance & Data Analyst | Chartered Accountant | Figuring life and enjoying the little wins 💡
Nigeria Katılım Ocak 2020
376 Takip Edilen278 Takipçiler
Piggvest sent me my 2025 W.A.E.C result and I got an A1!
By the way, W.A.E.C means Wealth Accrued and Expanded Consistently
Thanks @piggyvest for the reality check.
We do better this year! 💪
English
Which tech skill would you love to learn as we move into 2026?
I’ll be in the CS selecting some people to enroll.
English
SELECT DriverID, SUM(Fare) AS Total_Fare
FROM Trips
GROUP BY DriverID
HAVING SUM(Fare) > 4000;
This returns drivers whose combined fares exceed 4000; in this case, DriverID 4.
Also note that we use HAVING instead of WHERE because it works on aggregated sums.
#SQL
The SQL Tribe@thesql_tribe
Do you really know SQL? 😊 Day 10/30 Using the table “Trips” below, can you write a query that will return drivers whose total fare exceeds 4000?
English
Answer: D
A or B; it depends on whether the database is case-sensitive.
LIKE '%ann%' and LIKE '%Ann%' both work if case sensitivity isn’t enforced.
I also broke down SQL wildcards earlier in the Day 5 challenge, so this one was an easy pick.
#SQL
The SQL Tribe@thesql_tribe
Do you really know SQL? 😊 Day 10/30 You want employees whose name contains “ann”. A. WHERE Name LIKE '%Ann%' B. WHERE Name LIKE '%ann%' C. WHERE Name LIKE '%Ann%' OR '%ann%' D. A or B (depending on case sensitivity)
English
Answer: A
SELECT * FROM Sales LIMIT 1; returns only the first row from the result set.
It does this because LIMIT 1 tells SQL to fetch just one record starting from the top of the query results.
#SQL
The SQL Tribe@thesql_tribe
Do you really know SQL? 😊 Day 9/30 What will this return? SELECT * FROM Sales LIMIT 1; A. Only the first row B. The last row C. A random row D. The first column
English
Answer: A; DROP DATABASE dbname;
Why the others are wrong:
B. DELETE DATABASE dbname: DELETE works for rows in a table, not entire databases.
C. REMOVE dbname: This is not a valid SQL command.
D. ERASE DATABASE dbname: Also not an SQL command; SQL doesn’t use “ERASE.”
#SQL
The SQL Tribe@thesql_tribe
Do you really know SQL? 😊 Day 8/30 Which SQL command is used to delete a database? A. DROP DATABASE dbname; B. DELETE DATABASE dbname; C. REMOVE dbname; D. ERASE DATABASE dbname;
English
Happy new month! 🎉
December is finally here, and it’s my month!
Joy > stress all the way.
Let’s make it magical ✨
The SQL Tribe@thesql_tribe
December is here🎄!
English
Answer: C
SELECT * FROM Users WHERE Email IS NOT NULL;
Using IS NOT NULL is the correct way to check for non-null values in SQL.
#SQL
The SQL Tribe@thesql_tribe
Do you really know SQL? 😊 Day 7/30 How do you retrieve all rows where Email is NOT NULL? A. SELECT * FROM Users WHERE Email != NULL; B. SELECT * FROM Users WHERE Email NOT NULL; C. SELECT * FROM Users WHERE Email IS NOT NULL; D. SELECT * FROM Users WHERE Email <> "";
English
@Mrczar_ This is my ‘before’ comment. I’ll come back with the ‘after’ soon.
English
I am doing something entirely crazy:
If you have between N55,000 - N200,000 and looking for a profitable business to start:
I and my team are willing to help you start one.
I will give you Goods worth more than 1.8 million naira - FREE; you will not pay me a dime upfront.
I’ll show you ‘’my secret method’’ that you can use to sell them all off in under ONE MONTH.
I’ll also help you handle logistics, warehousing and delivery.
If this sounds like something you will be interested in, see my pinned tweet
English
Finishing strong > starting strong. The last stretch of the year can change your next one.
Benjamin Bennett Alexander@RealBenjizo
When everyone is slowing down as the year comes to an end; that's when you should go hard. Start a 30 day or 50 day challenge to learn Python ,SQL, Data analysis, etc. That will give a headstart for 2026. The goal is not to fit in; but to stand out; so move different.
English
@cyber_rekk I need support to get a laptop to aid my data analysis journey
English
If you want a gift this Christmas
Just tell me what you want in the comment
(I’m not buying anyone a car)
Mololuwa | Cybersecurity - (The God Complex)@cyber_rekk
Who wants a gift this Christmas?
English
@cyber_rekk Support to get a laptop to aid my data analysis journey
English
The correct answers are B & D
Why both work: It depends on the database you’re using:
👉🏾 TOP 5 is used in SQL Server (and MS Access).
👉🏾 LIMIT 5 is used in MySQL, PostgreSQL, SQLite, and most other modern databases.
Same goal, different “SQL accent”
#SQL #SQLServer
The SQL Tribe@thesql_tribe
Do you really know SQL? 😊 Day 6/30 How do you select only the first 5 rows from a table named Orders? A. SELECT 5 FROM Orders; B. SELECT TOP 5 * FROM Orders; C. SELECT * LIMIT 5 Orders; D. SELECT * FROM Orders LIMIT 5; Ps: there are two correct answers🙂
English
What do you need before December?
New phone
Laptop
Clear debt
Pay rent
₦1million
Business Support
Be sincere and follow make I fit dm you.
English
For the last time in 2025, I will send this to one lucky person. Thank you for an amazing 2025 @RaenestApp
English
We’re heading into the final stretch of the year, and it’s the best moment to strengthen your data portfolio with one last impactful project.
If you’ve worked with Annie before, you already know we learn out loud, build in public, and grow together.
This December, we’re kicking off the “15 Days Data Challenge with Annie.”
Are you in?
English
Correct answer: B
%son returns names that end with “son”.
This question is on SQL wildcards; symbols used with LIKE operator to match patterns in text.
👉🏾 %son → ends with “son”
👉🏾 son% → starts with “son”
👉🏾 %son% → contains “son” anywhere
#SQL #wildcard
The SQL Tribe@thesql_tribe
Do you really know SQL? 😊 Day 5/30 Which statement returns all customers whose name ends with “son”? A. SELECT * FROM Customers WHERE Name LIKE 'son%'; B. SELECT * FROM Customers WHERE Name LIKE '%son'; C. SELECT * FROM Customers WHERE Name = '%son';
English