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
18 SQL Practice Questions for Beginners
In this guide, we cover everything from filtering data to joining tables and aggregating data.
Start your SQL journey here ➡️
#SQL#SQLpractice#LearnSQL
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 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
Day 3: My Data Analyst Journey 🧵
Topics Covered: SQL
•Used GROUP BY and HAVING to group data
•Applied COUNT(), SUM(), AVG() for insights
•Practiced BETWEEN, IN, LIKE filters
•Analyzed sales by region & product type
#DataAnalytics#TechCareer#SQLPractice
18 SQL Practice Questions for Beginners
In this guide, we cover everything from filtering data to joining tables and aggregating data.
Start your SQL journey here ➡️
#SQL#SQLpractice#LearnSQL
Week 1 of the SQL Mentorship class at #LearnWithWIDA done!
We explored SQL-driven insights for WIDA Supermarket—analyzing sales, customer behavior, and product performance.
Scored 23/25 in the exam! Grateful for growth, ready for more.
#SQLPractice@ibn_wittig@LearnwithWiDa
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 4/30 of my #SQLPractice journey!
✅ Solved:
🏅 Rank Scores: Mastered the RANK() function
🗑️ Delete Duplicate Emails: Keeping data clean and unique
💰 Total Sales by Product: Aggregating like a pro
Excited to keep leveling up! 💻💡 #100DaysOfCode#SQL@LeetCode
Today's class was all about leveling up our SQL skills with some hands-on exercises. 🛠️ Plus, we had an insightful discussion on the amazing possibilities with ChatGPT! 🤖 #SQLPractice#TechEducation#ChatGPT
A standout data analyst portfolio can make all the difference. It's not just about possessing the skills, but the ability to showcase them.
Ready to build a portfolio that opens doors? Let’s get started ➡️
#SQL#SQLpractice#LearnSQL
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