Top Tweets for #50DaysOfSQL

about 1 year ago

Restarting my #50DaysOfSQL journey with a 5-day revision sprint! Day R1: • SQL Basics • Filtering with WHERE, IN, LIKE • Sorting + DISTINCT • Practice queries to warm up 🔥 Back in query mode after a 4-month break 😅 Let’s go! 🚀 #LearningInPublic #SQLChallenge #DataSkills

0

2

0

25

over 1 year ago

Day 19 of #50DaysOfSQL Explored the magic of 𝗦𝘂𝗯𝗾𝘂𝗲𝗿𝗶𝗲𝘀: • WHERE: Dynamic filtering • FROM: Derived tables • SELECT: Calculated metrics • Correlated Subqueries: Row-by-row comparisons #LearnInPublic #SQL #DataSkills

ps_preetsharma's tweet photo. Day 19 of #50DaysOfSQL

Explored the magic of 𝗦𝘂𝗯𝗾𝘂𝗲𝗿𝗶𝗲𝘀:
• WHERE: Dynamic filtering
• FROM: Derived tables
• SELECT: Calculated metrics
• Correlated Subqueries: Row-by-row comparisons

#LearnInPublic #SQL #DataSkills https://t.co/zX85LMIu4U

0

1

0

20

Michael Smart ( Data + Design) @MichaelSmart111

over 1 year ago

Day 18 of #50DaysOfSQL After a break, I'm restarting the series! 🚀 Spent today revising everything I’ve covered so far, from basic queries to window functions. Feeling ready to dive back into learning new concepts tomorrow! #SQL #LearnInPublic #DataSkills #SQLChallenge

ps_preetsharma's tweet photo. Day 18 of #50DaysOfSQL

After a break, I'm restarting the series! 🚀 Spent today revising everything I’ve covered so far, from basic queries to window functions. Feeling ready to dive back into learning new concepts tomorrow!

#SQL #LearnInPublic #DataSkills #SQLChallenge https://t.co/qg6bE640q9

0

1

0

23

over 1 year ago

Day 1 /50 (SQL CHALLENGE) Problem: identify hospital records where patients were admitted and discharged on the same day. SOLUTION: SELECT * FROM admissions WHERE admission_date = discharge_date; #SQL #data #sql #50DaysOfSQL #DataJourney

MichaelSmart111's tweet photo. Day 1 /50 (SQL CHALLENGE)

Problem: identify hospital records where patients were admitted and discharged on the same day.

SOLUTION:
SELECT *
FROM admissions
WHERE admission_date = discharge_date;

#SQL #data #sql #50DaysOfSQL #DataJourney https://t.co/v2pb18ooUC

0

6

2

0

318

Manjay Verma @CoderVerma

over 1 year ago

✅ Day 5 of #50DaysOfSQL: Solved a problem where I removed employees with non-unique IDs and replaced them with NULL. 🛠️ Great practice with SQL queries like JOIN, GROUP BY, and HAVING! On to the next challenge! 🚀 #SQL #LeetCode #DataScience #CodingJourney

CoderVerma's tweet photo. ✅ Day 5 of #50DaysOfSQL: Solved a problem where I removed employees with non-unique IDs and replaced them with NULL. 🛠️ Great practice with SQL queries like JOIN, GROUP BY, and HAVING! On to the next challenge! 🚀 #SQL #LeetCode #DataScience #CodingJourney https://t.co/pvbgj6GiLj

0

7

0

57

over 1 year ago

Day 17 of #50DaysOfSQL ✅ Mastered 𝗔𝗱𝘃𝗮𝗻𝗰𝗲𝗱 𝗪𝗶𝗻𝗱𝗼𝘄 𝗙𝘂𝗻𝗰𝘁𝗶𝗼𝗻𝘀: • Running Totals 📊 • Percentiles (PERCENT_RANK(), CUME_DIST()) 🏅 • Moving Averages 📈 • First & Last Values 🔍 Solved 1 questions on @hackerrank just keeps getting better! 🚀

ps_preetsharma's tweet photo. Day 17 of #50DaysOfSQL ✅

Mastered 𝗔𝗱𝘃𝗮𝗻𝗰𝗲𝗱 𝗪𝗶𝗻𝗱𝗼𝘄 𝗙𝘂𝗻𝗰𝘁𝗶𝗼𝗻𝘀:
• Running Totals 📊
• Percentiles (PERCENT_RANK(), CUME_DIST()) 🏅
• Moving Averages 📈
• First & Last Values 🔍
Solved 1 questions on @hackerrank just keeps getting better! 🚀 https://t.co/TjXWryXuKh

0

2

0

37

over 1 year ago

Day 1 of #50DaysOfSQL Started with the basics: what SQL is, how databases work, and tried my hand at creating and querying tables. It’s the start of many more SQL days to come! 🚀 #LearningInPublic #SQL #Data

ps_preetsharma's tweet photo. Day 1 of #50DaysOfSQL
Started with the basics: what SQL is, how databases work, and tried my hand at creating and querying tables. It’s the start of many more SQL days to come! 🚀 #LearningInPublic #SQL #Data https://t.co/GXKiZCW6pJ

0

1

0

24

Ishwari @ishwari03

over 2 years ago

✅Day 32 of #SQL Series LC Easy to Difficult SQL question & solution explained: Q. Report for every three line segments whether they can form a triangle. Return the result table in any order. Thread🧵 #100daysofcodechallenge #50daysofSQL

ishwari03's tweet photo. ✅Day 32 of #SQL Series
LC Easy to Difficult SQL question & solution explained:

Q. Report for every three line segments whether they can form a triangle. Return the result table in any order.

Thread🧵
#100daysofcodechallenge #50daysofSQL https://t.co/aVyUHIRMuf

1

6

1

0

206

over 2 years ago

Solved day8,day9,day10 of #50daysofsql #codedamn

1

3

0

105

Ishwari @ishwari03

over 2 years ago

✅Day 31 of #SQL Series Write a solution to report all employees w their primary dept. For employees who belong to 1 department, report their only department. Note->when employee belongs to only one department primary column is 'N' Thread🧵 #100daysofcodechallenge #50daysofSQL

ishwari03's tweet photo. ✅Day 31 of #SQL Series

Write a solution to report all employees w their primary dept. For employees who belong to 1 department, report their only department.
Note->when employee belongs to only one department primary column is 'N'

Thread🧵
#100daysofcodechallenge #50daysofSQL https://t.co/AlpJdu9Ba6

1

2

1

0

147

over 2 years ago

Day 7 of #50daysofsql in @codedamncom #codedamn

0

2

0

95

over 2 years ago

#Day6 of #50daysofsql Used count aggregate function to solve the problem

0

3

0

111

over 2 years ago

#DAY5 of #50daysofsql in #codedamn Used where clause,in to solve the problem

0

4

0

132

over 2 years ago

#Day3 of #50daysofsql Used like and where clause It was very Easy #codedamn

0

3

0

92

over 2 years ago

#Day2 of #50daysofsql #codedamn Used where clause

0

2

0

99

over 2 years ago

#day1 of #50DaysofSql .Solved the problem very easily #codedamn #SQL

0

3

0

122

over 2 years ago

Day 6: Using left join, I joined the Employees table to the EmployeeUNI table in order to obtain all records in Employees and their corresponding unique ID, and to set the unique ID of employees with no unique ID to NULL. Aliases increased runtime so I removed them🤧 #50daysofsql

Omo_Tayewo's tweet photo. Day 6: Using left join, I joined the Employees table to the EmployeeUNI table in order to obtain all records in Employees and their corresponding unique ID, and to set the unique ID of employees with no unique ID to NULL. Aliases increased runtime so I removed them🤧
#50daysofsql https://t.co/XV2KdIMpyx

over 2 years ago

Had my birthday and @alx_africa data viz task to deal with, hence the three day hiatus👉👈 Day 5: I applied the LENGTH function to count the number of characters in the tweet content to determine whether it's valid or invalid #50daysofsql

Omo_Tayewo's tweet photo. Had my birthday and @alx_africa data viz task to deal with, hence the three day hiatus👉👈
Day 5: I applied the LENGTH function to count the number of characters in the tweet content to determine whether it's valid or invalid
#50daysofsql https://t.co/2LuTk8Bbw9

0

2

0

89

0

3

0

90

over 2 years ago

Day 2: I initially didn't attach the OR statement until I checked the table and saw NULL referee ids. #50daysofsql