InnoTech

25/04/2026

Congratulations to all the participants of the 14 Days SQL Challenge 🎉👏

We celebrate your commitment, consistency, and willingness to learn 💪📚

Showing up every day, practicing, and pushing yourself to improve is not easy — but you did it! ✅

Over these 14 days, you didn’t just learn SQL — you built discipline, confidence, and a strong foundation in data skills 💻✨

Every query you wrote and every challenge you solved has taken you one step closer to your goals 🎯

We are proud of your progress and excited for what lies ahead for you 🚀
Keep learning, keep practicing, and keep growing 🌱

This is just the beginning of your journey 💫

Once again, congratulations on completing the challenge 🎊

Innotech IT Consultancy celebrates you! 💙

16/04/2026

Week 1 complete. Day 7 solutions! ✅
Innotech IT Consultancy is hosting a 14Days SQL challenge 🚀

Q1: Top 10 NY transactions 💰
sql

SELECT Store_State, Final_Amount, Product_Name
FROM transactions
WHERE Store_State = 'New York'
ORDER BY Final_Amount DESC
LIMIT 10;

Q2: Electronics >$100, last 30 days 📱
sql

SELECT Product_Category, Final_Amount, Transaction_Date
FROM transactions
WHERE Product_Category = 'Electronics'
AND Final_Amount > 100
AND Transaction_Date >= DATE('now', '-30 days');

Q3: Products with "Phone", highest rating first ⭐
sql

SELECT Product_Name, Customer_Rating, Final_Amount
FROM transactions
WHERE Product_Name LIKE '%Phone%'
ORDER BY Customer_Rating DESC;

Week 1 = DONE! Week 2 loading... 🔥

::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

📌 𝗜 𝗵𝗲𝗹𝗽 𝗴𝗿𝗼𝘄𝗶𝗻𝗴 𝗯𝘂𝘀𝗶𝗻𝗲𝘀𝘀𝗲𝘀 𝗳𝗶𝗻𝗱 𝗰𝗹𝗮𝗿𝗶𝘁𝘆, 𝗰𝘂𝘁 𝘄𝗮𝘀𝘁𝗲, 𝗮𝗻𝗱 𝗺𝗮𝗸𝗲 𝘀𝗺𝗮𝗿𝘁𝗲𝗿 𝗱𝗲𝗰𝗶𝘀𝗶𝗼𝗻𝘀 𝘂𝘀𝗶𝗻𝗴 𝘁𝗵𝗲𝗶𝗿 𝗱𝗮𝘁𝗮.

::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

📌 Want to grow in Data Analytics?

Join our 𝗧𝗲𝗹𝗲𝗴𝗿𝗮𝗺 community: https://t.me/LDAGW — 1,700+ pros learning together 🚀

Watch tutorials & past sessions on 𝗬𝗼𝘂𝗧𝘂𝗯𝗲: https://lnkd.in/eyiKwEjQ

Boost your skills with the 𝗜𝗻𝗻𝗼𝘁𝗲𝗰𝗵 𝗟𝗲𝗮𝗿𝗻𝗶𝗻𝗴 𝗔𝗽𝗽: iOS: https://lnkd.in/eCuUEHgq

Android: https://lnkd.in/e-36x3Bw

Grab quick tips on 𝗧𝗶𝗸𝗧𝗼𝗸: https://lnkd.in/excnpfQe

14/04/2026

Good morning, SQL fam! ☀️

Day 4 is complete! You're doing math in SQL now. Multiplying, dividing, calculating like a pro!

You're officially halfway through Week 1. 5 days straight of showing up. That's consistency. That's growth. Keep pushing! 💪

Day 5 of 14 Days of 🎯

Today's focus: WORKING WITH TEXT & STRINGS 📝

🔹 Q1: Show product names in UPPERCASE and lowercase. Display original Product_Name, UPPER(Product_Name), and LOWER(Product_Name).

✅ My Solution:

sql

SELECT Product_Name, UPPER(Product_Name) AS Name_Uppercase, LOWER(Product_Name) AS Name_LowercaseFROM transactionsLIMIT 10;

Approach: UPPER() converts everything to capitals. LOWER() converts to lowercase. Great for standardizing text!

🔹 Q2: Find all products that start with "Organic". Show Product_Name and Product_Category.

✅ My Solution:

sql

SELECT Product_Name, Product_CategoryFROM transactionsWHERE Product_Name LIKE 'Organic%'LIMIT 15;

Approach: LIKE 'Organic%' finds any product name starting with "Organic". The % means anything can come after.

🔹 Q3: Find all products that end with "TV". Show Product_Name and Final_Amount.

✅ My Solution:

sql

SELECT Product_Name, Final_AmountFROM transactionsWHERE Product_Name LIKE '%TV'LIMIT 10;

Approach: LIKE '%TV' finds any product name ending with "TV". The % before means anything can come before.

📘 Learnings:

Today's "aha!" moment 💡:

The % wildcard is like a magic wand. Put it before, after, or both to find patterns anywhere in the text!

What I learned:

UPPER() / LOWER() = change case

LIKE = pattern matching

% = matches ANY characters (zero or more)

'Organic%' = starts with Organic

'%TV' = ends with TV

'%phone%' = contains "phone" anywhere

You're mastering text search! Now you can find anything in your data. 🎯

Day 5 done ✅ 9 to go!

13/04/2026

Write SQL on your Mobile 🚀
Innotech IT Consultancy is host a 14Days of SQL challenge

🎯 Day 4 of 14 Days of

Now it’s time to level up your SQL skills by adding a little math to the mix 💻✨

Today’s Focus: BASIC MATH in SQL ➕✖️
Let’s get practical 👇
🔹 Q1:
Calculate the total amount before discount (Quantity × Unit_Price)
→ Name it Total_Before_Discount
→ Show: Product_Name, Quantity, Unit_Price, and your result
🔹 Q2:
Find the final price per unit (Final_Amount ÷ Quantity)
→ Show: Product_Name, Quantity, Final_Amount, and price per unit
🔹 Q3:
Convert discount percentage to decimal (Discount_Percent ÷ 100)
→ Show: Discount_Percent and Discount_As_Decimal
💡 Hints:
• Use * for multiplication
• Use / for division
• Use AS to name your column
• For decimals, use 100.0 instead of 100
Drop a ✅ when you solve them! Let’s grow together 🚀

To join the Challenge 👇🏾

Join our 𝗧𝗲𝗹𝗲𝗴𝗿𝗮𝗺 community: https://t.me/LDAGW

— 1,700+ pros learning together 🚀

Watch tutorials & past sessions on 𝗬𝗼𝘂𝗧𝘂𝗯𝗲: https://lnkd.in/eyiKwEjQ

Boost your skills with the 𝗜𝗻𝗻𝗼𝘁𝗲𝗰𝗵 𝗟𝗲𝗮𝗿𝗻𝗶𝗻𝗴 𝗔𝗽𝗽: iOS: https://lnkd.in/eCuUEHgq

Android: https://lnkd.in/e-36x3Bw

Grab quick tips on 𝗧𝗶𝗸𝗧𝗼𝗸: https://www.tiktok.com/?_r=1&_t=ZS-95Rgf6G0K5B

And LinkedIn:https://www.linkedin.com/company/innotech-it-consultancy/

11/04/2026

11/04/2026

Celebrating 1,000 followers on LinkedIn today! 🎉
We are truly grateful to each and every one of you for your support and connection. Your engagement means a lot to us at Innotech IT Consult.

We pray that your efforts yield great results, your plans succeed, and your paths are filled with favor and progress 🙏

We’re excited for what’s ahead — and we’re committed to bringing you even more value, insights, and opportunities.

Thank you for being part of our journey 💙

::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

📌 Want to grow in Data Analytics?

Join our 𝗧𝗲𝗹𝗲𝗴𝗿𝗮𝗺 community: https://t.me/LDAGW

— 1,700+ pros learning together 🚀

Watch tutorials & past sessions on 𝗬𝗼𝘂𝗧𝘂𝗯𝗲: https://lnkd.in/eyiKwEjQ

Boost your skills with the 𝗜𝗻𝗻𝗼𝘁𝗲𝗰𝗵 𝗟𝗲𝗮𝗿𝗻𝗶𝗻𝗴 𝗔𝗽𝗽: iOS: https://lnkd.in/eCuUEHgq

Android: https://lnkd.in/e-36x3Bw

Grab quick tips on 𝗧𝗶𝗸𝗧𝗼𝗸:https://www.tiktok.com/?_r=1&_t=ZS-95Rgf6G0K5B

And LinkedIn :https://www.linkedin.com/company/innotech-it-consultancy/

11/04/2026

10/04/2026

Join this 14-Days of SQL Challenge to own your skills.
Most people trying to learn SQL struggle with one thing…
👉 Consistency

They start, stop, and never really get better.

So we decided to fix that.
📢 2-Week SQL Challenge ( 𝗕𝗲𝗴𝗶𝗻𝗻𝗲𝗿 → 𝗔𝗱𝘃𝗮𝗻𝗰𝗲𝗱)

We’re kicking off a structured SQL challenge to help you:
✔ Build real SQL skills
✔ Stay consistent

🗓 Start Date: Friday, 10th April 2026.

📌 How it works:
• Learn together as a community
• Solve tasks daily (no matter how small)
• Use the 𝗜𝗻𝗻𝗼𝘁𝗲𝗰𝗵 𝗟𝗲𝗮𝗿𝗻𝗶𝗻𝗴 𝗔𝗽𝗽

🎯 Goal:
Grow from 𝗕𝗲𝗴𝗶𝗻𝗻𝗲𝗿 → 𝗔𝗱𝘃𝗮𝗻𝗰𝗲𝗱 and stay accountable

📲 Get started here:
App Store: https://lnkd.in/eCuUEHgq

Play Store: https://lnkd.in/e-36x3Bw

💬 Important:
𝗪𝗵𝗲𝗻 𝘆𝗼𝘂 𝗰𝗼𝗺𝗽𝗹𝗲𝘁𝗲 𝗮 𝘁𝗮𝘀𝗸, 𝘀𝗵𝗮𝗿𝗲 𝘆𝗼𝘂𝗿 𝗽𝗿𝗼𝗴𝗿𝗲𝘀𝘀 — 𝗰𝗼𝗻𝘀𝗶𝘀𝘁𝗲𝗻𝗰𝘆 𝗶𝘀 𝘁𝗵𝗲 𝗴𝗼𝗮𝗹
𝗪𝗲’𝗿𝗲 𝗻𝗼𝘁 𝗷𝘂𝘀𝘁 𝗹𝗲𝗮𝗿𝗻𝗶𝗻𝗴…
𝗪𝗲’𝗿𝗲 𝗯𝘂𝗶𝗹𝗱𝗶𝗻𝗴 𝗱𝗶𝘀𝗰𝗶𝗽𝗹𝗶𝗻𝗲 𝗮𝗻𝗱 𝗿𝗲𝗮𝗹 𝘀𝗸𝗶𝗹𝗹𝘀 🚀

♻️ Repost to help someone stay consistent
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
📌 𝗜 𝗵𝗲𝗹𝗽 𝗴𝗿𝗼𝘄𝗶𝗻𝗴 𝗯𝘂𝘀𝗶𝗻𝗲𝘀𝘀𝗲𝘀 𝗳𝗶𝗻𝗱 𝗰𝗹𝗮𝗿𝗶𝘁𝘆, 𝗰𝘂𝘁 𝘄𝗮𝘀𝘁𝗲, 𝗮𝗻𝗱 𝗺𝗮𝗸𝗲 𝘀𝗺𝗮𝗿𝘁𝗲𝗿 𝗱𝗲𝗰𝗶𝘀𝗶𝗼𝗻𝘀 𝘂𝘀𝗶𝗻𝗴 𝘁𝗵𝗲𝗶𝗿 𝗱𝗮𝘁𝗮.
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
📌 Want to grow in Data Analytics?
👥 Join our 𝗧𝗲𝗹𝗲𝗴𝗿𝗮𝗺 community: https://t.me/LDAGW
— 1,700+ pros learning together 🚀

Watch tutorials & past sessions on 𝗬𝗼𝘂𝗧𝘂𝗯𝗲: https://lnkd.in/eyiKwEjQ

Grab quick tips on 𝗧𝗶𝗸𝗧𝗼𝗸: https://lnkd.in/excnpfQe”