Cosmas Mwirigi@MwirigiCosmas1
Day 7 of #100DaysOfSQL 🚀
Today: changing data with UPDATE, changing tables with ALTER COLUMN, and working with dates in PostgreSQL.
A thread 🧵👇
Code and notes:
30230
Posts with #100DaysOfSQL
#100DaysOfSQL
Public posts on X that use #100DaysOfSQL.
Related hashtags
iam@iamuhammdDay 1: SQL Challenge🚀 A retail store tracks all transactions in: Sales(order_id,customer_id,product_id, order_date,amount) -Management asks: Which customers spent more than the avg spend in June 2025, but less than the avg spend in July 2025 #SQL #DataAnalytics #100DaysOfSQL113454
Esther 💙@Etty_officialDay 49/100 of my SQL learning journey... Today, I focused on learning IF and IFNULL in SQL. As I was practicing, I couldn’t help but notice the similarity between IFNULL and COALESCE, which I had learnt earlier same as IF and CASE WHEN...... #100DaysOfSQL #LearningInPublic
115100- Cosmas Mwirigi@MwirigiCosmas1Day 8 of #100DaysOfSQL 🚀 Today: EXTRACT, CASE expressions, subqueries, CTEs and UNION. My queries are starting to look like real analysis. A thread 🧵👇 Code and notes:20030
- Esther 💙@Etty_officialDay 42 of 100 days SQL learning Today, I did a mini SQL project and applied everything I’ve learned so far from Self Joins to Triggers, Views, CTEs, UDFs, and more. I also explored Pivoting & Unpivoting to transform and analyze my dataset better #DataAnalytics #100DaysOfSQL
035109 
Armani@armani0GKPracticing SQL transformations with the AdventureWorks2022 database! I used CASE statements to: • Classify product prices • Categorize stock levels • Flag weekend orders • Recommend discount tiers Solid way to level up my SQL skills! #100DaysOfSQL #DataAnalytics #SQLServer
24461.4K
Data is Life@kafilat_yekeenDay 29 of #100DaysOfSQL Delete Duplicate Emails Focus: DELETE with subquery + ROW_NUMBER() Used ROW_NUMBER() over Email to flag duplicates. Deleted rows where row_num > 1. Ensured only 1 unique email per user. Learned data cleaning with DELETE + window functions. #DataAnalytics
Data is Life @kafilat_yekeenDay 28 of #100DaysOfSQL Find Followers Count Focus: COUNT() + GROUP BY Counted followers per user with COUNT(follower_id). Grouped by user_id to get totals. Ordered results for clarity. Reinforced basic aggregation and grouping skills. #DataAnalytics #100DaysOfCode026292- Data is Life@kafilat_yekeenDay 28 of #100DaysOfSQL Find Followers Count Focus: COUNT() + GROUP BY Counted followers per user with COUNT(follower_id). Grouped by user_id to get totals. Ordered results for clarity. Reinforced basic aggregation and grouping skills. #DataAnalytics #100DaysOfCode
006319 - Data is Life@kafilat_yekeenDay 33 of #100DaysOfSQL Group sold products by the date Discovered the power of GROUP_CONCAT() today while solving today's task Instead of returning multiple rows, GROUP_CONCAT() lets you combine values into one string. #100DaysOfCode #DataAnalytics
Data is Life @kafilat_yekeenDay 32 of #100DaysOfSQL Task: Get employee names with no bonus or bonus < 1000. Focus: Used LEFT JOIN + IS NULL / < 1000. Highlights employees below bonus threshold. #DataAnalytics #100DaysOfCode037248 - Data is Life@kafilat_yekeenDay 32 of #100DaysOfSQL Task: Get employee names with no bonus or bonus < 1000. Focus: Used LEFT JOIN + IS NULL / < 1000. Highlights employees below bonus threshold. #DataAnalytics #100DaysOfCode
019341 - Data is Life@kafilat_yekeenDay 38 of #100DaysOfSQL Confirmation Rate Key takeaway: Learned how to calculate confirmation rates by joining signups with confirmations, handling missing records with LEFT JOIN, and using ROUND() for precise decimals. #DataAnalytics #100DaysOfCode
Data is Life @kafilat_yekeenDay 37 of #100DaysOfSQL Friend Requests II – Who Has the Most Friends Key takeaway: Learned how to treat friendships as bidirectional by combining sender & receiver IDs with UNION ALL, then grouping to count total friends per user. #DataAnalytics #DataScience #100DaysOfCode015181 - Data is Life@kafilat_yekeenDay 37 of #100DaysOfSQL Friend Requests II – Who Has the Most Friends Key takeaway: Learned how to treat friendships as bidirectional by combining sender & receiver IDs with UNION ALL, then grouping to count total friends per user. #DataAnalytics #DataScience #100DaysOfCode
013185 - Cosmas Mwirigi@MwirigiCosmas1Day 9 of #100DaysOfSQL 🚀 First practice day: 3 SQL challenges on the Kenyan job market, easy to hard, on 787,686 real job postings. A thread 🧵👇 Code and notes:1009
Vyom Srivastava@vyom_srivastavaTop 15 Best Web Servers: HTML #MySQL #100daysofcode #100daysofsql #sql #mysql #MySQL #Oracle #webdeveloper #FrontEndDeveloper #backenddeveloper010- Esther 💙@Etty_officialDay 3 of #100DaysOfSQL 📊 Today I explored: -ORDER BY for sorting results -Column/table aliases for cleaner queries -LIMIT (MySQL) & TOP (SQL Server) to control rows returned I think I'm enjoying this 😂
119483 - Esther 💙@Etty_officialDay 33 of SQL Learning Today, I learnt TEMPORARY TABLES. - Learnt they only exist during a session. - Practiced creating, inserting, and selecting from temp tables #SQL #DataLearning #100DaysOfSQL
11381 - Esther 💙@Etty_officialDay 50/100 of my SQL learning journey Today I learnt about ENUM and SET data types in SQL useful for restricting column values to predefined options. On to the next! #100DaysOfSQL #SQL #LearningData
03674 - Esther 💙@Etty_officialI know this is coming a bit late , I had a long and hectic day Today, I learned about the difference between EXISTSand IN in SQL. After understanding how each works and where they apply in solving queries, I jumped into MySQL Workbench to practice them.#100DaysOfSQL #SQL
027220 
DILIP KUMAR@DilipKumar2410Solved today in SQL: Bank Account Summary II Every query executed is a step closer to cleaner data and stronger logic. #SQL #Database #100DaysOfSQL #DataSkills #LeetCode
3012167- Esther 💙@Etty_officialDay 4 of #100DaysOfSQL Today, I learned aggregate functions: - COUNT() - SUM() - AVG() - MIN()/ MAX() I also took time to practice my previous day’s work, reinforcing SELECT statements, filtering, and sorting with these new functions. #SQL #DataAnalytics
2413406 - Esther 💙@Etty_officialDay 21 of #100DaysOfSQL Today I explored Ranking Functions in SQL: ROW_NUMBER() RANK() DENSE_RANK() #SQL #DataAnalytics #LearningInPublic #100DaysOfCode
3411280 - Esther 💙@Etty_officialDay 34 of SQL Learning Today was all about understanding the difference between Derived Tables and CTEs.They both help you build temporary tables in a query but CTEs? Cleaner, reusable, and easier to read. Derived tables? Quick and sometimes messy.#SQL #100DaysOfSQL
02370 - Data is Life@kafilat_yekeenDay 30 of #100DaysOfSQL Immediate Food Delivery II Goal: Find the %of customers who received their first order on the same day they placed it. Focus: Group by customer, check first order date vs. preferred delivery date, then compute percentage. #100DaysOfCode #DataAnalytics
Data is Life @kafilat_yekeenDay 30 of #100DaysOfSQL Rising Temperature 🌡️ Goal: Identify days where the temperature was higher than the previous day. Focus: Self join on the same table, compare consecutive days, and filter rising temps. #100DaysOfCode #DataAnalytics147166 - Data is Life@kafilat_yekeenDay 30 of #100DaysOfSQL Rising Temperature 🌡️ Goal: Identify days where the temperature was higher than the previous day. Focus: Self join on the same table, compare consecutive days, and filter rising temps. #100DaysOfCode #DataAnalytics
Data is Life @kafilat_yekeenDay 29 of #100DaysOfSQL Delete Duplicate Emails Focus: DELETE with subquery + ROW_NUMBER() Used ROW_NUMBER() over Email to flag duplicates. Deleted rows where row_num > 1. Ensured only 1 unique email per user. Learned data cleaning with DELETE + window functions. #DataAnalytics012295 - Show more posts
