Next up: · More JOINs (RIGHT, FULL) · Subqueries & CTEs · Window functions Slow progress > no progress. #DataEngineer #SQLPractice #BuildInPublic

#100DaysSQLChallenge We have two tables: users -- (user_id, user_name, followers) events -- ( user_id, post_id, post_views) Problem Statement: Write a SQL query to find Top Instagram Creators based on these conditions: ✔️ Minimum followers: 20,000 ✔️ At least 2 posts ✔️ Total post views > 2 Lakhs Expected Output: Creator Name Followers Count Post Count Total Views SQL Concepts Used: 🔹 JOINs 🔹 Aggregate Functions 🔹 GROUP BY 🔹 CTEs 🔹 Filtering with multiple conditions 🔹 ORDER BY 💡 Real-world use case: This type of query can help brands identify influencers for collaborations based on reach engagement metrics. Day 1/100 ✅ Follow along if you're preparing for: #SQLInterviews #DataAnalytics #DataEngineering #BusinessAnalytics #SQLPractice #100DaysSQLChallenge #Learning #Analytics #DataScience #LearnSQL #StarSQL

Analicé qué instructores aparecen más en el Top 5 usando CTEs y DENSE_RANK. Respuesta paso a paso: sqlenvivo.com/respuesta-inst… #SQLTips #SQLPractice #DataSkills #QueryOptimization #DataProblems #SQL #answers

🔹 Window functions – calculating running totals, ranks, and group-level insights… while still keeping every single row visible! It’s amazing how these tools let you go from raw messy data → clean, powerful business insights in just a few lines. #SQLPractice #DataAnalytics

Day 10 completed 🚀 From nested SQL queries & joins to HTML tables—turning theory into hands-on practice. Showing up daily. Learning loudly. Improving silently. 💻📈 #Day10 #LearningInPublic #SQLPractice #DeveloperJourney #Consistency

📘 BASIC SQL (cont.) 1. Total sales by region SELECT region, SUM(amount) AS total_sales FROM sales GROUP BY region; 2. Departments with avg salary > 60k SELECT department, AVG(salary) FROM employees GROUP BY department HAVING AVG(salary) > 60000; 3. Orders between Jan–Mar 2024 SELECT * FROM orders WHERE order_date BETWEEN '2024-01-01' AND '2024-03-31'; 4. Customers with >3 orders SELECT customer_id FROM orders GROUP BY customer_id HAVING COUNT(*) > 3; #SQLPractice #DataJobs

Day 3 ✅ Hands-on SQL filtering using WHERE, LIKE, IN, NULL conditions SDLC Prototype Model revision. Small progress daily leads to big results. 🔥 #SQLPractice #Day3Learning #SDLC #PrototypeModel #Consistency #LinkedInLearning

i promise when you'll be interviewing for your first data job the main culprit behind your rejection will be sql it’s the same language that only has 5-6 "simple" repeating english words yet most of you will choke during the live coding round why? because you watched tutorials but never practiced interview questions use these free platforms that'll help you crack the hard-core sql interviews → sqlzoo (best place for beginners) → sqlpractice-com → datalemur → namastesql → stratascratch → hackerrank → codechef lock yourself in solve at least 1 interview question every single day for the next 30 days no excuses in breaking the streak on the 30th day, your confidence will be at a level you won't believe you can thank me later

#Day2 | #SQLPractice | #HackerRank Revising the Select Query II Problem: lnkd.in/gqEWynQP Solution: htmlify.me/r/axxd #day2 #hackerrank #sql #htmlify #sabkacode

Day 4 of learning SQL 🔍 Diving into string functions, subqueries, and self joins applied everything I’ve learned so far! Check out Data with Gloria's video👇🏽#TikTok vt.tiktok.com/ZS5cqHXm9/ #datawithgloria #data #SQLPractice #DataAnalytics #LearningInPublic

SQL Practice: Question: Employee Bonus (Easy) Solved using LEFT JOIN Practicing one query at a time. #Consistency #SQLPractice #LearningInPublic

Day 6 of SQL Practice Question: Rising Temperature Solved using: SELF JOIN DATEDIFF() - Good reminder that sometimes the table itself is the best reference. #SQLPractice #LeetCode #LearningInPublic #Day6

Day 5 of SQL Practice Question: Delete Duplicate Emails Solved using: DELETE Subquery 📌Learnings: • How to remove duplicates safely • Revised DELETE vs DROP vs TRUNCATE #SQLPractice #LeetCode #LearningInPublic #Day5

Day 4 of SQL Practice Question: Customers Who Never Order Solved using: LEFT JOIN IS NULL Key takeaway: Always use IS / IS NOT with NULL, = doesn’t work with NULL values in SQL. #SQLPractice #LeetCode #LearningInPublic #Day4

Day 3 of SQL practice Solved: Duplicate Emails Learned that with GROUP BY, we must use HAVING for conditions. (Using WHERE earlier caused errors 😅) #Leetcode #SQLPractice #LearningInPublic #Day3

Day 2 of SQL Practice Question: Employees Earning More Than Their Managers Solved using a SELF JOIN (cross product condition) #SQLPractice #Leetcode #Day2

Day 1 of practicing SQL Question: Combine Two Tables Solved using LEFT JOIN Key takeaway: In PostgreSQL we have "FULL OUTER JOIN", while in SQL we use "UNION" to achieve the same result. #LeetCode #SQLPractice #LearningInPublic

🛢️ #SQLPractice - ресурс з практичними задачами задачі, який допомагає підготуватися до співбесід та підтягнути знання #SQL sql-practice.com/

#Day96 — SQL Deep Dive 💻✨ Small steps, daily progress. Today I learned: ▫ SQL Clauses ▫ UPDATE / DELETE ▫ ALTER / TRUNCATE solved practice problems 🔍 The consistency is paying off. 🌱 #CodingJourney #100DaysOfCode #SQLPractice