AJ

Aspiring Data Analyst

[AJ @shemustexcel]

@MrCharlesky please i’m interested

[AJ @shemustexcel]

@JobFound5 interested

[Abiodun @realAdeyemo]

Hiring: Virtual Assistant
Salary: 300,000-400,000/month
📍 Remote

Employment Type: Part-time

✅ Job Summary
- We are looking for detail-oriented Virtual Assistants to support our daily operations.
- You will handle administrative tasks, social media management, community engagement, data entry, and customer inquiries.
- This is a hands-on role where you will work directly with the founder and operations team.

[AJ @shemustexcel]

@AndrewBolis Money

[AJ @shemustexcel]

@realAdeyemo hi i’m interested in this role

[AJ @shemustexcel]

@Y0BESH i’m interested

[AJ @shemustexcel]

@zillionokoye i’m interested

[AJ @shemustexcel]

@zandyor 💗💗💗

[Obed @theobed__]

https://t.co/sY8sxtrgrc

[AJ @shemustexcel]

FULL OUTER JOIN → Returns all rows from both tables
CROSS JOIN → Returns the Cartesian product (every row from one table paired with every row from the other).
SELF JOIN → A table joined with itself, useful for hierarchical data like employees & managers

[AJ @shemustexcel]

Day 17–19 of my SQL journey
I finally tackled JOINS in MySQL and at first, it was really confusing, but practicing made it click.
Here’s a breakdown 🧵
#100DaysOfCode #SQL #DataAnalytics

[AJ @shemustexcel]

INNER JOIN → Returns only rows with matches in both tables.
LEFT JOIN → Returns all rows from the left table + matches from the right (NULL if no match).
RIGHT JOIN → Returns all rows from the right table + matches from the left (NULL if no match).

[AJ @shemustexcel]

Types of SQL Joins:
INNER JOIN
LEFT JOIN
RIGHT JOIN
FULL OUTER JOIN
CROSS JOIN
SELF JOIN

Each one decides how rows from two tables are combined.

[AJ @shemustexcel]

Day 14–16 mySQL
Learned logical functions:IFNULL, IF, CASE for conditional queries.
Practiced date functions:DATE_ADD, DATE_SUB, DATEDIFF, CURRENT_DATE, TIMESTAMPDIFF.
Used COALESCE to handle NULLs.
Wrote queries to calculate employee age &group them into categories.
#SQL #Data

[AJ @shemustexcel]

@web3tings Yesss

[AJ @shemustexcel]

Day 13 of mySQL challenge
I worked on converting text-based dates into proper SQL date formats using STR_TO_DATE().
When importing data, dates often come in as plain text (e.g. 2020-05-12, or 01-Jan-2003). This can cause problems if you want to run calculations or filtering.
👇

[AJ @shemustexcel]

To fix this, I used UPDATE with STR_TO_DATE to transform those text fields into actual DATE values. For example:

[AJ @shemustexcel]

Day 10–12 of mySQL Challenge

Day 10 – Learned GROUP BY with aggregates like SUM to find total salaries per department.
Day 11 – Used MAX with GROUP BY to find the country+language with the highest speakers.
Day 12 – Practiced HAVING to filter aggregated results.

#SQL

[AJ @shemustexcel]

@matiecodes Yep, in MySQL both LIKE and REGEXP are case insensitive by default

[AJ @shemustexcel]

Day 9 of MySQL challenge

Today,I dived into pattern matching with LIKE & REGEXP.
I practiced filtering employees by job titles, listing Sakila actors starting with “S”, pulling Nigerian cities from World DB, and finding countries ending with “A”.
SQL + REGEXP = data sniper 🎯