Practicing SQL to enhance my skill #sqlpractice #sqlday1

Day 4 – IDC 21 Days of SQL w/ #DPDzero Task: Get the 3rd to 7th highest patient satisfaction scores 👇 Learning rank logic = better control over real-world data slices 🔍 On to Day 5 🚀 #21DaysSQLChallenge #SQLWithIDC #IndianDataClub #SQLPractice #DataAnalytics #Day4

Practicing aggregate functions and grouping in SQL using the AdventureWorks2022 database.Covered: COUNT, SUM, AVG, MIN, MAX GROUP BY HAVING Reviewing my queries and sharpening the basics.#SQL #DataAnalytics #100DaysOfSQL #SQLPractice #AdventureWorks #datafam

Day 8 – IDC 21 Days of SQL w/ #DPDzero Task: Show patient_id, full name in UPPERCASE, service in lowercase, age category , and name length — only names >10 chars 👇 On to Day 9 🚀 @dpdzero @indiandataclub #21DaysSQLChallenge #SQLWithIDC #IndianDataClub #SQLPractice #Day8

Day 3 – IDC 21 Days of SQL w/ #DPDzero Today's task: find top 5 weeks with highest patient refusals 👇 Spotting refusal trends = key for healthcare ops & patient experience 💡 On to Day 4 🚀 #21DaysSQLChallenge #SQLWithIDC #IndianDataClub #SQLPractice #DataAnalytics #Day3

Utilizing time wisely through revisiting SQL basics and sharpening my database skills. #ProductiveDay #SQLPractice

For my first assignment, I imported flat files into SQL (named locations) and practiced writing queries to filter, sort, and group data. Seeing results instantly is so satisfying! @TDataImmersed #SQLPractice #DataSkills

MY SOLUTION i will be solving it in two ways: SELECT c.Customer_Name Customer_name, SUM(t.amount) total_amount FROM customers c JOIN transaction t ON c.Customer_id=t.Customer_id WHERE EXTRACT(YEAR FROM t.transaction_date) = '2024' GROUP BY 1; #SQLQuery #SQLPractice

WHERE yearr = '2024'; That's the end Understing the question is very important. It says "total transaction amount for each customer for the current year". -- customer -- SUM(total amount) as total_amount -- year -- join tables together #SQLQuery #SQLPractice

Took on “The Blunder” on @hackerrank ... Let’s just say the problem name was accurate 😂 But it helped me learn the REPLACE() function — Small mistake, solid lesson 🙌 #SQLPractice #BuildInPublic #HackerRank #TechTwitter

DAY 47: Here is the solution for #SQLPractice Problem on Day 40

DAY 48: Here is the solution to the #SQLPractice Problem from Day 40.

📊 SQL grind today: Tables ✔️ Data ✔️ Keys ✔️ Queries ✔️ #SQL #SQLQueries #SQLPractice #LearnSQL #MySQL #PostgreSQL #SQLDeveloper #Database #DatabaseDesign #QueryLanguage #SQLTips

Day 2 – IDC 21 Days of SQL w/ #DPDzero Today's task: filter patients in Surgery with satisfaction < 70 👇 Learning SQL one query at a time — real data, real insights 💪 On to Day 3 🚀 #21DaysSQLChallenge #SQLWithIDC #IndianDataClub #DataAnalytics #SQLPractice #Day2

Day 6 – IDC 21 Days of SQL w/ #DPDzero Task: Get admissions, refusals & admission rate per service 👇 Understanding rates > raw counts — real service performance insights 📊 On to Day 7 🚀 @indiandataclub #21DaysSQLChallenge #SQLWithIDC #IndianDataClub #SQLPractice #Day6

Day 4 of my LeetCode SQL Journey! Today I solved 2 more SQL questions and every query is making me better at thinking logically and writing cleaner code. Consistency is the key, and I’m enjoying the process of improving step by step. #LeetCode #SQLPractice #DataScience

Day 14 – IDC 21 Days of SQL w/ #DPDzero Created a staff utilisation report showing all staff + how many weeks they were present. 👇 LEFT JOIN + COALESCE = data completeness 💪 @dpdzero @indiandataclub #21DaysSQLChallenge #SQLWithIDC #SQLPractice #DataAnalytics #Day14

Learn SQL the smart way. Practice > Theory. ✅ https://t.co/0apqnkqpaR – Interactive lessons ✅ https://t.co/AgAghluNAf – Interview-style problems ✅ https://t.co/mRJMDp2SsR – Technical SQL challenges Type ‘SQL PRACTICE’ if you know any of them. #SQLPractice #DataSkills

DAY 27: #SQLPractice Problem Answer