Day 16✅Of 100DaysOfSQL challenge
Today I Solved an interesting question on sql joins,in which I had to find the sum of maximum score per challenge.
#DataCommunity#SQL#100DaysOfCode#DataScience
Day 14✅Of 100DaysOfSQL challenges
Wrote a SQL query that filters hackers by challenge count.
Keeps those with the highest count
Keeps those with a unique count
Removes repeated non-max counts
Nested logic + CTE = brain workout 😅
#SQL#100DaysOfSQL#DataSkills
Day 12✅ Of 100DaysOfSQL challenge
Solved yet another question of Basic joins.
Challenge :Mask names for grade<8,sort by grade desc ,then name or marks based on grade.
#SQL#DataCommunity#100DaysOfSQL
Day 10✅ Of 100DaysOfSQL challenge
Today I solved an interesting question , Find the median of the lat_n column that divides the data into 2 halves . I have explored row_number(),over(), and subquery .
If you are into data field let's connect.
#DataCommunity#SQL#100DaysOfSQL
Day 9✅ Of 100DaysOfSQL challenge
😥Missed posts few days due my college project submission crunch, but the streak lives on!
Today’s challenge: mastering Aggregation .
Let’s keep pushing!
#SQL#DataChallenge
Day ✅8 Of 100DaysOfSQL challenges
Today I solved a sql question on basic aggregation ,calculated the amount of error and round up to the next integer.
#SQL#DataCommunity#100DaysOfCode
Day ✅6 & 7Of 100DaysOfSQL challenge
Solved a binary tree node challenge using advanced SELECT logic.
Practiced basic aggregation (SUM) today.
Learning daily, posting consistently—even if a day late 😉
#SQLChallenge#DataJourney#DataCommunity
Day✅5 of 100DaysOfSQL challenge! Just solved an advanced select problem on Had to generate 2 result sets:
1) alphabetized list of names with profession's 1st letter in parentheses.
2) occupation counts in ascending order, formatted with a twist!
#SQL#DataCommunity#SkilledUp
Day✅4 Of 100 DaysOfSQL challenge
Tackeled yet another advanced sql query .Arrange the same occupation people in same column
Approach
CTE → assigns a row number to each name within their occupation.
MAX(CASE) → pivots those rows into columns, grouping them by row number. #SQL
Day 2✅ Of 100 DaysOfSQL challenges
Today I explored JOIN, GROUP BY, and COUNT(DISTINCT) to summarize company-wise employee hierarchy. Used MAX(founder) to safely pull non-grouped data.
#SQL#Data#Datacommunity #100DaysOfSQL
Day ✅1 of 100 DaysOfSQL
Started with basic select exploring filtering with WHERE ,sorting with ORDER by and REGEXP for pattern matching
#DataEnthusiast#SQL
Hey guys I am starting #100DaysOfSQL today! 🎯
Why?
To sharpen my skills, share insights, and connect with fellow data enthusiasts. Expect dashboards, dry-run logic, query breakdowns, and real-world use cases.
Let’s make SQL storytelling fun. Join me? #DataCommunity#SQL
Hello everyone 👋,
Sharing my recent project where I explored e-commerce churn data. I used Python (pandas) for EDA and then built an interactive Power BI dashboard.
Dataset: Kaggle
Tools: Python, Power BI
#DataAnalytics#PowerBI#Python#EDA#ChurnAnalysis
160GFG Challenge Completed✅
What started as a challenge became a habit—160 days of problem-solving, debugging, and leveling up my DSA skills!
Thank you @geeksforgeeks .
#160gfgchallenge#womenintech
Day 160✅Of 160gfg Challenge
Problem-Unique Number II
Approach-Similar to the Unique Number I problem,in todays problem just store the answer in array, sort the answer array and return it.
#160gfgchallenge@geeksforgeeks#womenintech
Day 159✅Of 160gfg Challenge
Problem-Unique Number I
Approach-Create a HashMap and track the occurence of each element . The element in map whose value ==1 return that element.
#160gfgchallenge@geeksforgeeks#womenintech
128 Followers 72 FollowingFrontend Dev Intern → turning real on-the-job problems into public lessons. React • JS • UI. Learning in public, one bug at a time.
5K Followers 4K FollowingA JavaScript Junkie 💻 | Tech content Creator ✍️ | Talks about Corporate World & Healthy Developer Life 🤸♂️| In deep love with Nature 🌿 | Love Chess♟️
129 Followers 72 FollowingFrontend Dev Intern → turning real on-the-job problems into public lessons. React • JS • UI. Learning in public, one bug at a time.
7 Followers 10 FollowingI am a Power BI dashboard developer passionate about turning complex data into simple, interactive visuals. I create dashboards that help businesses track.
8 Followers 0 FollowingWith 3 years of experience as a Power BI Developer, I excel in creating dynamic visualizations and insightful reports. My advanced proficiency in DAX, ETL .
3K Followers 2 FollowingTransform your career & business with our expert-led IT courses and top-notch services. Elevate your skills and drive digital innovation https://t.co/eUNJujHC4v
23K Followers 223 FollowingPower BI reports that make a difference 🚀 training 1.1M + followers in Power BI across social platforms 👉🏼https://t.co/lWIqE7UzQo https://t.co/lWIqE7UzQo
5K Followers 4K FollowingA JavaScript Junkie 💻 | Tech content Creator ✍️ | Talks about Corporate World & Healthy Developer Life 🤸♂️| In deep love with Nature 🌿 | Love Chess♟️
820 Followers 178 FollowingHelping Real Estate Agents scale
Losing deals to slow response or focusing on unqualified leads
🤖 I fix that with AI
DM "SYSTEM" to see how it works
1K Followers 575 FollowingUTA alumni. Let me help you out with your algebra, calculus, stats, economics, finance, Excel, Java, Spss, Geo, Bio, Chem phy classes. My rates are affordable.
42K Followers 2K Followingsoftware , ai research and education | ai @samsung | Startups | Ex-ISRO | Educator | 700K+ YT & IG | Reachout on mail : [email protected]
898 Followers 0 FollowingGet your daily dose of updates, fun facts, interview questions and more!
Charge Up your Career 💪
Get ready to become the next Pepcoder!🧐🧑💻